cancel
Showing results for 
Search instead for 
Did you mean: 

How to sort records based on the 4 fields

Former Member
0 Kudos

Hi XI Experts,

Scenario is File to IDOC and i need to do some sorting over here. That is

Sort all records by CustomerID/EmployeeID/AssetID/Assettype.

I know only for two fields we can use Standard function SortbyKey.

Please suggest me here how can i sort this based on the four fields above.

Thanks in advance.

Regards,

Y.Raj.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Concat all the 4 fields and map with sort function in node level.

Concat all the 4 fileds and map each fields using sortbykey function.

Regards,

Prakasu.M

Answers (1)

Answers (1)

jyothi_anagani
Active Contributor
0 Kudos

Hi YeswanthRaj Kumar,

You can sort 4 times. Like sort First with Customer ID then take that values and sort with EmployeeID and take result and then sort with AssetID...........Like ths you can do.

Thanks.