I am new to Alteryx and have mostly used SAS Enterprise Guide.
I am wondering if there is a way to sort and then select the first record of each sort by group.
Solved! Go to Solution.
Yes! Check out the sample tool. Here you can select the 'First N' records, in your case 1.
It also allows you to select fields to 'group by', which means the expression ends up as...
Select me the first n records for each member in these groups.
Have a play and let us know if this brings you to the solution you need!
https://help.alteryx.com/current/Sample.htm
Ben
Yup! I see it now....right in front of me.
Learning a new tool again is great! haha
I'm just happy to know that you've been freed from EM.