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 |
Solved! Go to Solution.
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:
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.
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
Thank you @chinu267, this really helped me deliver a deliverable today.
Thank you for attached workflow 🙂
Absolute Pleasure Manjari.
Please mark this solution as solved for me.
Thank you @Jonathan-Sherman your solution worked like a charm.
Thank you for taking out time 🙂