I have two excel files attached screenshot for your reference:
When comparing above 2 excel sheets I need output like
I have two excel files attached screenshot for your reference:
When comparing above 2 excel sheets I need output like
Hi @gokulvasant ,
Could you let us know why the Output contains only details upto F5
? What is the logic used for the comparison ?
Hello @gokulvasant
Try this
Hi @gokulvasant
Should your output be a datatable containing all the output values next to your first shown Excel File?
Helpful for you is to use the “Lookup Data Table” Activity to get the Reason from your second Datatable - search for the current code in column ‘Status Code’ and get the CellValue of column ‘Reason’ as your Output, i.e. as the Variable ‘str_Reason’).
After this, add an Assign Activity to concatenate your Code with the Reason:
str_Result = str_Code + " - " + str_Reason
Then, depending on your desired result, you could either print this value or assign your Row-Item accordingly (i.e. when looping through all values - For Each Row - in the first Excel/DataTable).
Best regards
Roman