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
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
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.
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
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
Hi!
To filter as <> in HCI you must use !=
This is how the system will understand that you want to filter not equal.
Ralph