Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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