Hi,
I am trying to skip the first row for each grouping in my data. How can I do this?
Example data:
Name | Data 1 | Data 2 |
John | 1 | 2 |
John | A | B |
Mike | 3 | 2 |
Mike | F | G |
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
Solved! Go to Solution.
Hi @Link86
The sample tool can help here. You can set it to skip the 1st record and group by Name. See below configuration.
Can this be done with a multi field formula tool?
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.
Awesome, thank you.