HCI-DS Filter unwanted data in Records

[Former Member]

Hi SAP Community.

Im trying to filter out a record with a invalid value, please let me explain.

KF1 LOCID LOCFR KF2

XX1 LOC01 LOC03 100

XX2 LOC02 LOC04 200

'0' LOC05 '0' 200

Basicly i want to remove all the records with KF = '0'. I tryed in filters doing this "Transform.KF1 <> '0' ".

Thanks in advance.

Best Regards

[former_member288194 · Accepted solution]

Hi Luis,

In HCI-DS, you can exclude records using the "filter" tab in the transforms.

Here is an example with standard ECC table KNVV :

I hope this helps you,

Pierre

[Former Member · Accepted solution]

Thanks, I was mistaken on the operators, i was trying to use a not equal operator like this "<>" but the operator used was "!=", thanks a lot.