Grab second instance from data table

Hey I have a data table where i need to remove the first instance.

For example

Name Type Outcome
Bill One Error
Jake Two Completed
Bill One Completed

I want to remove the first instance of bill. I need to remove the entire row.

Hi @Asanka
Check this workflow and excel file for reference

Main.xaml (7.2 KB)
input.xlsx (10.6 KB)


Nived N

Happy Automation

remove specific index row or remove by filtering column to specific character?
both of them have their own best practices

Hey thanks for this. But I need it to be a little bit more dynamic. The example I used was very simple. There could be 100 entries in the file with all sorts of names. I need to look at all the names and only keep the second entry for all the names. Does that make snese? There could be 2 Jake entries, 2 Nived entries and I want to keep the second entry for both.