Delete rows that are don't exist in one CSV file

I would like to be able to delete rows that are not found in one CSV file against another CSV as I am trying to remove the redundant data where some of the rows are not needed. Below is the project code and the issue is with the else statement.
Main.xaml (10.1 KB)

Hi @Stabbathehut

If you want to remove that row by RowIndex, assign a variable to the Output Index of your “For each CSV row” activity and use it as the index.

HTH

Troy

Hi Troy, could you give an example of this please

I don’t have your files to check the entire workflow but here is where you need to get the current cvsRowIndex

image

This error is occuring now even

Maybe you can try it as bellow:

1 Like

[index = index -1] need to be added in loop.