@rpathak not sure your issue in Diff snap or sort, can try below option in sort snap. Also if you are going to use Diff snap, both the side should have same set of attribute and name of all attribute in both end should same. Incase if any set of data you don’t have value, add mapper and put null or blank.
Assuming your input is a single document with an array of objects, rather than a stream of individual documents.
With that assumption you can use a mapper with the expression:
jsonPath($, "$[*].tree") and target path: tree
This will collect all tree objects from every element in the array, then write that list to the target path tree
Need counts of 20+ Tables from Source & Target into a .xls file | SnapLogic - Integration Nation - 10669
