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

binuacs
20 - Arcturus

@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