Select by sort by group

[khannan]

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. 

[BenMoss · Accepted 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

[MarqueeCrew · Accepted solution]

@khannan,

First use a SORT tool and then use a SAMPLE tool (configured as FIRST N Records) with the "Group by" field(s) checked.

Cheers,

Mark

[khannan]

Yup! I see it now....right in front of me. 

Learning a new tool again is great! haha

[MarqueeCrew]

I'm just happy to know that you've been freed from EM.