How to compare or match the two different excel files

Hey,
i have two excel files and i want to match that all the column of two excel files and if its match then update Yes in status column in CPO excel file and if it is no then update No in same column

CPO.xlsx (8.6 KB)

SAPInput.xlsx (9.3 KB)

Hi!

have a view on this thread

Regards,
NaNi

sorry
but file is not opening giving error could not find file
if you have that work flow please send me xml file

Hi @kailas_jadhav

Use read range activity to read excel files

then use for each datatable activity to iterate excel -1
inside the loop use another for each activity to iterate excel - 2

inside the second loop use if activity to match both the excel rows Ex: Currentrow1(“Column1”)=Currentrow2(“Column1”)

Thanks,

Hi @kailas_jadhav

Please refer to the xaml below based i have created a file based on your reqiurement!

new_Sequence.xaml (8.5 KB)

Regards

sorry…
the sequence is missing and invalid activity showing

Hi @kailas_jadhav

Please refer to the screen shots below to proceed!

Regards

1 Like