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.

[former_member414511]

Hi!

To filter as <> in HCI you must use !=

This is how the system will understand that you want to filter not equal.

Ralph

[Alecsandra]

Hi Luis Arturo,

Do you try to export from IBP? As i remember, IBP does not support Key Figure filtering, meaning that it has to happen at HCI level. So after extraction query from IBP table, bring one more query where filter will be performed.

Best

Alecsandra

[Former Member]

Hi Alecsandra, Im importing data from a Z Table of ECC to IBP, my question is: Is there a way on HCI-DS that an Ifthenelse statement choose not to map a record?

Best regards

Luis Cabello