ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need to select last two rows from list

Ekmi9
8 - Asteroid

Hello Everyone,

 

I need to select last two rows based on Id.

 

Input

Ekmi9_0-1670232933213.png

Output

 

Ekmi9_1-1670233026780.png

Appreciate your Help !

4 REPLIES 4
ShankerV
17 - Castor

Hi @Ekmi9 

 

Please use sample tool to get the desired output.

 

Many thanks

Shanker V

binu_acs
21 - Polaris

@Ekmi9 One way of doing this with the sample tool

 

binuacs_0-1670233219545.png

 

ShankerV
17 - Castor

Hi @Ekmi9 

 

Use as highlighted below.

 

ShankerV_0-1670233223980.png

Select Groupby ID

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Ekmi9 

 

Input: 

ShankerV_0-1670233371856.png

 

My workflow:

ShankerV_1-1670233392420.png

ShankerV_2-1670233439437.png

 

Output:

ShankerV_3-1670233454860.png

 

Many thanks

Shanker V

 

Labels
Top Solution Authors