Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

binuacs
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