I want to crosscheck these two datatable/sheet of excel and raise a flag if there is a mismatched entry. The column I is manually written here to express my expected output.
I can crosscheck the two datatable/excel sheet and print output in excel file but now I want to rasie a status flag on the first sheet/db based on mismatched entry.
How may I write the status flag?
Main - Copy (1).xaml (90.1 KB)
In this following workflow, I can print mismatced row, but instead of that I want to print a status flag with corresponding row in a new column.