I am trying to join two data table from two different excel by two columns,
In excel1 I want to compare “Sheet1” column “H” and column “I” with excel2 with column “B” and “D” and in another sheet put the column “NUMERO SUCURSAL” and “NUMERO DEPARTAMENTO”
first I get the DT1 then DT2 and I use join data tables activity and DT3 comes out but when I write it in excel it doesn’t write anything to me
Excel1
Excel2
Datatable 3 (Join) this is what should come out in the end
first I get the DT1 then DT2 and I use join data tables activity and DT3 comes out but when I write it in excel it doesn’t write anything to me
Excel2.xlsx (10.3 KB) Excel1.xlsx (14.1 KB)
I hope you can help me