Remove the last row/record in the group

[Jennyman130]

Hi all,

I would like to setup a logic to remove the last row in the same group id as highlighted below. Not sure if it's possible? Many thanks.

Group ID	Revision	Amount
1	1	19.5
1	2	-19.5
1	2	19.5
1	0	-19.5
2	0	10
2	1	-10
2	1	10
2	1	-10

[LordNeilLord · Accepted solution]

Hey @Jennyman130

Anything is possible in Alteryx, it's just how you get there :)

Using the sample tool here can help to solve this problem..

[Jennyman130]

Thank you so much! Nothing is really impossible in Alteryx!