topic Re: How to join two tables with multiple column? in QlikView

How to join two tables with multiple column?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have created my tables using SQL statements in the Data Load Editor. I know that if the columns of two table are the same name they will be joined, however how do I join three columns of the two table together?

Re: How to join two tables with multiple column?

jaumecf23 — Tue, 03 Apr 2018 12:52:04 GMT

You will need to create a new field with the concatenation of the values of these three fields in both tables.

Re: How to join two tables with multiple column?

vishalarote — Tue, 03 Apr 2018 12:55:48 GMT

Make it Composite Key :

e.g

MainTable:

Load

Column1'-'Column2 as [Composite Key],

Data1

From Table1;

left join(MainTable)

Load

Column1'-'Column2 as [Composite Key],

Data2

From Table2;

Re: How to join two tables with multiple column?

Anonymous — Tue, 03 Apr 2018 12:57:44 GMT

I am using the plain SQL no Qlik expressions can I generate composite key on the plain sql?

Re: How to join two tables with multiple column?

vishalarote — Tue, 03 Apr 2018 13:04:53 GMT

Yes u just Concate the field

select (Column1,Column2) as Composite Key,Data1

from Table1;

select (Column1,Column2) as Composite Key,Data2

from Table2;

after that use join

select a.Composite Key,b.composite key, Data1, Data2

from Table1 a left join Table2 b

where a.Composite=b.Composite;

Re: How to join two tables with multiple column?

vishalarote — Tue, 03 Apr 2018 13:05:32 GMT

where a.Composite Key=b.Composite Key