Sort function in translation map
Sorting data in translation map
Input data:
1,123,def
3,345,xxx
2,234,bcd
Simple CSV map is:
- If we want to sort per ID, extended rule in INPUT (root) record, On-End must be:
sort($record,#ID);
Screenshot follows:
And the result/output is:
1,123,def
2,234,bcd
3,345,xxx
- Extended rule for sort per stringField, in ascending order, is:
sort($record,#stringField);
... or ...
sort($record,#stringField asc);
... and the result is:
2,234,bcd
1,123,def
3,345,xxx
- Extended rule for sort per stringField, in descending order, is:
sort($record,#stringField desc);
... and the result is:
3,345,xxx
1,123,def
2,234,bcd
