I need to compare two files based on one column and output to excel file if match is found.can anyone give me the logic how to do it using For each row activity.
My current logic as as follows:
for each row firstable
body: assign the value of the firsttable column value to one variable1
for each row secondtable body : assign the value of the secondttable column value to one variable2 then do compare variable1 = variable 2
can you give me the complete logic to achieve this asap