Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Skip first row for each group

Link86
8 - Asteroid

Hi,

I am trying to skip the first row for each grouping in my data. How can I do this?

 

Example data:

NameData 1Data 2
John12
JohnAB
Mike32
MikeFG

 

I want the formula to return A B for John and FG for Mike. It won't always be letters and numbers so a regex wont work.

 

Thank you

4 REPLIES 4
Luke_C
17 - Castor

Hi @Link86 


The sample tool can help here. You can set it to skip the 1st record and group by Name. See below configuration.

 

Luke_C_0-1623785823775.png

 

Link86
8 - Asteroid

Can this be done with a multi field formula tool?

Luke_C
17 - Castor

A multi-field formula tool would just apply a formula across multiple columns, so I don't think that achieves what you're looking for. You could probably use a multi-row formula tool to flag the first row for each name followed by a filter tool, but that seems like extra work compared to the sample tool.

Link86
8 - Asteroid

Awesome, thank you. 

Labels