I have 2 Excel sheets data.xlsx & data1.xlsx.
data.xlsx (9.6 KB)
data1.xlsx (10.5 KB)
I am reading for each row from data.xlsx as outer loop and data1.xlsx as inner loop and matching the amount.
If the Amount is matched, I need to update Status1 = Yes (data1.xlsx), Status = Yes (data.xlsx) and copy the Number column value from (data1.xlsx) to New Number Column (data.xlsx) simultaneously.
As per the data, if there are more than 1 matching records, it should pick first matching record.
I tried various methods but could not get the solution. Any help or xaml would be highly appreciated.