Picking up a row based on max value
I have a usecase in which I get the files from some software that has record as follows -
Item Account Paid …
1 2.05
1 1.00
1 3.05
2 4.00
3 5.00
No...
Forum Discussion
My output should look something like this -
1 3.05
2 4.00
3 5.00
By using Aggregate Snap you can achieve your scenario. Please find below screen shot for reference.
Also I have attaching the sample snaplogic pipeline. please check it. Hope this is useful for you!
SL_COMM_SC1_2018_03_19.slp (3.2 KB)
