Mapping - Translation

Sort function

Sort function in Map Editor
Mirjana's picture

Sort function in translation map

Submitted by Mirjana on Sun, 09/04/2011 - 11:39
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
admin's picture

Documents (SI, XML, EDI, protocols ...)

Submitted by admin on Sun, 01/09/2011 - 09:31

You can find 4 main groups of documents for now:

  • Communication protocols
  • Sterling Integrator
  • Sterling File Gateway
  • XML

We will try to cover some topics that beginners as well as advanced users can find useful.
If you have any suggestion about topics you would like to see explained or if you have any document you would like to share with Community, please let us know. 
Please, be aware that is not an official documentation, but documents written by users and published to be shared with you, so please tolerate mistakes that you can find.
 

Syndicate content

Library

Main Menu

User login

Login/Register

Tell a friend

Send an e-Postcard

New forum topics

Recent Posts Recent Posts