Excel Name “Master.xlsx” having User Name list i.e. A,B,C
Another excel Name “Data.xlsx” having data of various users like A,B,C,D,E,F.
Now I have to take each user from Master.Xlsx and check them in Data.xlsx. if user exist in Data.xlsx then delete these rows from Data.xlsx… Please help
Make sure you’re unzipping the contents: Processusvierge.zip (14,5 Ko) . Also, make sure you have the dependencies installed that are listed in the project.json file.
If this doesn’t work, follows these steps:
1.) Read each dataset using 2 different Read Range activities.
2.) Create a For Each Row loop on the data from Master.
3.) Use Filter Datatable to remove row("Users").ToString from the table from Data.xlsx
@Shirish, your workflow looks like it should work. If there are spaces in one of the fields for the username, this can cause the match not to be found. Can you check if this is what’s happening?