Find the last row with in the same ID

[Manjari]

Hi All, 

Requesting help in finding the last row with in a ID

sample data: 

User ID	Favorites
1001	Apple
1001	Mango
1001	Apple
1002	Jack fruit
1002	pineapple
1002	Apple
1002	Mango

I would like to filter out only the last row like the below

1001	Apple
1002	Mango

[Zas3NfkB]

Hi @Manjari  you can do that using the sample tool with the below configuration. Selecting the last n (in this case 1) and grouping by ID

[Manjari]

Thank you @Zas3NfkB 

This worked great, after implementing this into my original data set i realized I want the output to be like this:

User ID	Favorites	Last row status
1001	Apple
1001	Mango
1001	Apple	Last row per ID
1002	Jack fruit
1002	pineapple
1002	Apple
1002	Mango	Last row per ID

Sample filters the rest of the columns that I need. apologies for not explaining well.

[Jonathan-Sherman · Accepted solution]

Hi @Manjari,

I think this is what you're trying to achieve?

Input:

Output:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[chinu267 · Accepted solution]

See the attached solution if it helps you achieve what you need. Mine is Alteryx 2020.2 and if yours is lower, please open the YXMD file in notepad++ on the top change the version to whatever is yours, save and reopen to run

[Manjari]

Thank you @chinu267, this really helped me deliver a deliverable today. 

Thank you for attached workflow 🙂

[chinu267]

Absolute Pleasure Manjari.

Please mark this solution as solved for me.

[Manjari]

Thank you @Jonathan-Sherman your solution worked like a charm. 

Thank you for taking out time 🙂