Hi All,
Requesting help in finding the last row with in a ID
sample data:
I would like to filter out only the last row like the below
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
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
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
Thank you @Zas3NfkB
This worked great, after implementing this into my original data set i realized I want the output to be like this:
Sample filters the rest of the columns that I need. apologies for not explaining well.
Thank you @Jonathan-Sherman your solution worked like a charm.
Thank you for taking out time 🙂
