Skip to Content
avatar image
-1
Former Member

HCI-DS Filter unwanted data in Records

Oct 11, 2016 at 12:58 AM | 799 Views

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

SAP Cloud Platform Integration tools
SAP Integrated Business Planning | SAP Data Services | hci-ds
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2016 at 06:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 18, 2016 at 03:15 PM

      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.

  • avatar image
    Alecsandra Dimofte
    Oct 12, 2016 at 02:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 14, 2016 at 05:03 PM

      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

  • avatar image
    Former Member
    Jun 06, 2017 at 07:02 PM

    Hi!

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

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

    Ralph

    Add comment
    10|10000 characters needed characters exceeded