How to compare new file with response file in excel automation

Hi , need to check if any row in response file is present but not in new file then it has to be removed AND if any row which is available in in both file needs to be kept but has to be picked from response file.
responseFile.xlsx (9.7 KB)
NewPO.xlsx (8.8 KB)

and the output shoulb like

Hi @ahmed4566

Can you try the below

Sequence2.xaml (11.6 KB)

Output:

Regards,

Thank you Mam, its exactly the same output I was looking for …Please sugust How can I learn to use invoke code…thank you very much

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.