Dynamic Route

Dynamic Route in Stelring File Gateway
Mirjana's picture

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
Mirjana's picture

2. Dynamic Route

Routing Channel Template for DYNAMIC ROUTE
 
 
 
Routing Channel for DYNAMIC ROUTE
 
 
File test_DYNAMIC_ROUTE.txt is uploaded to 'producer' MBX, and we can see arrived, route and delivery events in the following screenshots for the dynamic route that routes a message from producer's MBX to consumer's one based on route, and also that runs a BP after routing:
Note: File in a consumer's MBX (consumer_DR) is an original one, not translated!!!
 
 
 
 
Message is placed into consumer’s MBX (consumer_DR) with extractability 1, and as such can be seen in MyFileGateway
 
 
MyFileGateway for consumer_DR
 
 
Error in a BP, VDC_SFG_translation, during Dynmic Route
 
Error in Filegateway
 
 
 
Error in Dashboard, BP Monitor

Syndicate content