Skip to Content
0

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

Mar 14, 2017 at 02:58 PM

210

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sriprasad Shivaram Bhat Mar 14, 2017 at 03:31 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded
Chendrakala Vennapusa Mar 14, 2017 at 06:10 PM
0

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


branch-b.png (29.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Sriprasad Shivaram Bhat Mar 14, 2017 at 06:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded