Join two data tables by two columns

Help
,
1

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
image

Excel2

image
image637×605 14.2 KB

Datatable 3 (Join) this is what should come out in the end

image
image787×165 4.31 KB

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

2

Hi Ivan,

Can you please elaborate little more on the join condition that you are using ?
is it like the below one?

image

If it is an inner join you dont have data that matches both the join condition, that may be the reason for not finding any data on the DT3. Please correct me on your join condition I would be able to help you out.

Thanks

3

Hello friend, I did just that same condition as you mentioned and indeed my DT3 does not bring me anything even if the columns have the same name

4

Problem is that condition doesn’t satisfy any data in the final result. As the values in EXcel 2 are in lower case compared to values in Excel1 so inner joins may not find any result. If you change the data to be upper case you will get some inner join results.

5

I will try to change everything to uppercase

6

Check this attached workflow, @Ivan_torres_oliva
Uipath_JoinTables.zip (27.2 KB)
Hope this may help you :slight_smile:

7

If I want to extract not equal data, how can I chage the workflow. Please let me know. Thanks.