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)
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
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,
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