Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
13 - Pulsar

Hi @Ekmi9 

 

Please use sample tool to get the desired output.

 

Many thanks

Shanker V

binuacs
17 - Castor

@Ekmi9 One way of doing this with the sample tool

 

binuacs_0-1670233219545.png

 

ShankerV
13 - Pulsar

Hi @Ekmi9 

 

Use as highlighted below.

 

ShankerV_0-1670233223980.png

Select Groupby ID

 

Many thanks

Shanker V

ShankerV
13 - Pulsar

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