Sorting all nodes with a key !

[former_member216332]

Hello experts,

This is my scenario....

If field 'Parts' exist in source, 'E1BPSDITM' is formed in target with their subnodes mapped to one another.

'Parts' has about 15+ subnodes. Two of them are 'PartsNo' & 'PartsQty'.

I am to sort the PartsNo in ascending order & incase the PartsNo is same, the PartsQty is to be sorted in descending order & create the IDOC.

Sorting the 'PartsNo' or 'PartsQty' just changes the induvidual values.

Is there a way to sort all 'E1BPSDITM' fields with respect to 'PartsNo' using graphical mapping?

NOW

After Mapping

Thanks in advance for any help.

Regards

Sam

[markangelo_dihiansan · Accepted solution]

Hello Sam,

You can use this logic: The second sort after formatByExample is in descending order.

Hope this helps,

Mark

[gagandeep_batra]

Hi Sam,

Plz find the below i have tried with Employee record

Rgards

Gagan

[former_member216332]

Hi Gagandeep Batra,

I understand It can be done for induvidual fields but in my case, there are about 15-20+ subnodes with complex mappings. To change them all is going to be a Himalayan task . If there's a way to sort the 'E1BPSDITM' fields with respect to 'PartsNo' ('row' field itself with respect to 'EMP_NO' in your case), It would be helpful.

Thanks & Regards

Sam

[gagandeep_batra]

Hi Sam,

if PartNo is single then it would be very simple but in your case dependency is also on part quantity

so it cause the complex logic with it.

other option is you can check with UDF also

Regards

Gagan