Join or Concatenate

Black_Hole — Sat, 16 Nov 2024 02:33:30 GMT

Hello all,

I would like to join two tables using a common key (ID).

#1 : The source of the first table is a connection to a database.

#2 : The source of the second table is an excel file.

I tried to join these tables using a left join.

The IDs which are in the excel file, but not in my database are not recuperated in the result of joined table.

And that's my problem! In my result, I would like to have the result of the joined table and also the IDs which are not in the database (and vice versa, the IDs which are not in my excel file but not in my DB).

Please could you advise which join function I need to use in order to find the result describe above.

Thank you in advance for your help.

Re: Join or Concatenate

StarinieriG — Thu, 05 Sep 2019 15:13:19 GMT

Hi,

so, if don't want to lost rows, try to use simply "Join"

Re: Join or Concatenate

Black_Hole — Thu, 05 Sep 2019 15:20:49 GMT

Hi @StarinieriG ,

Great, I try it and I find the expected result.

Many thanks for your quick and effective reply!

topic Re: Join or Concatenate in QlikView

Join or Concatenate

Re: Join or Concatenate

Re: Join or Concatenate