I want to map data of two excel sheets in such a way that the value should be updated only if row name match. Col3 is empty.
[Col1] [Col2] [Col3]
A| 12 |43
B |14 |9
D |90 |63
I have used Join Data table activity, It worked but order is different. It was require to update the Col3 in Excel 1 on the basis of Column1 value of Excel2