Now I have to untick the numbers any of those number available 100,200,300 from Second ID Column Header, So I unticked 100,200( as only those were avaiable)
Now I have to delete the records which comes after doing steps 1 and 2. So as of now I have only 1 row as u can see the above image, so I will delete this.
Now I will clear all the filters and my final table look like this:
@iamgeet Have you tried to do this similar Operation using Filter Datatable Activity by Reading the Excel File as a Datatable using Read Range Activity?
@iamgeet So you want to remove rows if “First Id” Column has values 1,2,8,9 and 11 and also if “Second Id” Column does not have the Values 100, 200, 300. Is that right ?
@iamgeet Check this Workflow :
I have Initiialised two Arrays based on your Condition, I think the Output is what you need. Try the Workflow for your data and check if it satisfies all the requirements.
