topic Re: Left join in QlikView

Left join

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

I have two tables,one is having columns a,b,c,d,e

And other table having columns a,b,c,d,g,h.

How to perform left join now?

There are more than 1 common column.

Also if this first table is having 20 records. So after left joning with second table, records count shud remain same right?

Re: Left join

Clever_Anjos — Wed, 22 Nov 2017 16:36:56 GMT

table:

load

a,b,c,d,e

from yourqvd(qvd);

left join(table)

load a,b,c,d,g,h

from otherqvd(qvd);

Re: Left join

YoussefBelloum — Wed, 22 Nov 2017 16:38:47 GMT

Hi,

just put LEFT JOIN between the first and the second LOAD

example:

table1:

LOAD a,b,c,d,e from table1...

left join

table2:

LOAD a,b,c,d,g,h from table2...

you will have:

table1 with: a,b,c,d,e,g,h

Re: Left join

its_anandrjs — Wed, 22 Nov 2017 17:56:06 GMT

You can do this way also

First way

Table1:

Load

a&'_'&b&'_'&c&'_'&d as Key,

From Source;

Join(Table1)

Table2:

Load

a&'_'&b&'_'&c&'_'&d as Key,

g,h

From Source;

Second Way

Table1:

Load

a,b,c,d,e

From Source;

Join(Table1)

Table2:

Load

a,b,c,d,g,h

From Source;