Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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];
Hi,
try to use trim for each key, maybe there are spaces
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".