Join two tables (resident and Excel file)

[Black_Hole]

Hello all,

I have two tables to join.

The source of the first table is a resident table. The source of the second table is a xlsx file.

I tried to join these two tables but my join doesn't work. Indeed, in my table two lines are created (see attached file).

Please could you tell me how can I avoid this kind of issue.

Thank you in advance for your help.

[Arthur_Fong]

It might be due to both of the table has a same column which is not a key column.

For example if you want to join LastTranDate, (ItemNo and Designation as the key columns)  from Excel to resident table:

join(ResidentTable):

load ItemNo,

Designation,

LastTranDate

from [ExcelPath];

[StarinieriG · Accepted solution]

Hi,

try to use trim for each key, maybe there are spaces

[Black_Hole]

Hello @StarinieriG , @Arthur_Fong ,

Thank you both of you for your help.

The problem has been resolved using the trim function and also by putting a "Distinct".