Skip to Content
avatar image
Former Member

Data Filtering issue in the SAP HCI/PI with custom Mapping

The Process is Getting the Payload from SF from Compound-employee SFAPI. we are mapping with the custom XSD ( Custom Field mapping ). After mapping them we have to filter the data in different conditions of Event = 'H' and few more. And after filleting we are trying to create the files and transmit then with SFTP to different destinations.

Challenges :

1. After mapping we trying to split using general splitter so as to check each employee record. after which we try route them on the condition as mentioned above and then we are trying to gather.

And we are attaching the data after mapping.sample.txt

sample.txt (1.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 14, 2017 at 03:31 PM

    Hello Chandralekha,

    If you are splitting 15 Records and in the later stage you want to gather,then Gather step expect all the split message will reach the Gather step.

    Its not possible to use Router in between Splitter and Gather.

    Instead of that you can use below pattern.First branch filter will group all the compound employee records with Event=H and other branch will do the opposite.

    Post filter step you can do the transformations as per your requirement.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2017 at 06:10 PM

    Hi Sriprasad,

    Thanks for the prompt reply and understanding.

    As you have described the condition as EVENT = H and EVENT != H is the final condition. We have done the same but we got the reply as TRUE or FALSE in the FILE/MAIL.

    Now we are not getting the desired out put, so am here by providing the detailed screen and flows. In our case we have just assumed "PayrollNumber" feild as inputs and same is mapped.

    Kindly suggest.

    branch-a-fliter.pngbranch-b.png

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14, 2017 at 06:33 PM

    Hello Chandrakala,

    In general I have mentioned that above condition just for representation.

    You must use below condition

    /CompoundResponse/CompoundEmployee[PayrollNumber = 'H' ]

    Also this filter will remove the root node and post filter step you must reform the XML message with root node.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded