cancel
Showing results for 
Search instead for 
Did you mean: 

Sort not working.....

aakumar
New Contributor III

Json data is in the file attachment. Below is my sort snap. I need the data to be sorted based on ToCurrency.Code. But sort results data is not sorted. Sort not working on this json.

@lakshmi Manda  

 

 

aakumar_0-1710263099963.png

 

1 ACCEPTED SOLUTION

tlikarish
Employee
Employee

The sort operates on a document by document basis, but the input to the snap contains only 1 document. In order to sort on the field you'd like you'll need to first split the document into multiple documents, sort those, then group them back together. Here's an example that demonstrates how you could do that sort of thing.

tlikarish_0-1710264982810.png

 

View solution in original post

2 REPLIES 2

tlikarish
Employee
Employee

The sort operates on a document by document basis, but the input to the snap contains only 1 document. In order to sort on the field you'd like you'll need to first split the document into multiple documents, sort those, then group them back together. Here's an example that demonstrates how you could do that sort of thing.

tlikarish_0-1710264982810.png

 

aakumar
New Contributor III

Thank you.