topic Join two tables (resident and Excel file) in QlikView

Join two tables (resident and Excel file)

Black_Hole — Sat, 16 Nov 2024 02:27:43 GMT

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 — Wed, 18 Sep 2019 00:01:58 GMT

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 — Wed, 18 Sep 2019 08:12:07 GMT

Hi,

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

Black_Hole — Thu, 19 Sep 2019 13:28:08 GMT

Thank you both of you for your help.

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