I have a usecase in which I get the files from some software that has record as follows -
Item Account Paid …
Now, I want to select the records having max value from account paid.It is like data base query pick max( account paid) group by item in RDBMS world.
I was able to group records but is there a way where I can select max( account paid ) value using snap ?
Any help much appreciated here…