topic Re: Join Problem in QlikView

Join Problem

k_burata — Tue, 25 Aug 2015 06:42:23 GMT

Hi all,

How would you do this T-SQL statement to QlikView?

SELECT

A.Key1,

B.Key1,

A.Data1,

A.Data2,

B.Data3

FROM A

LEFT JOIN B

ON A.Key1=B.Key1

I am particularly after how to display A.Key1 and B.Key1 which I can do in T- SQL

Thanks

Re: Join Problem

mightyqlikers — Tue, 25 Aug 2015 06:56:57 GMT

hi Kim,

use alias in sql query itself.

Regards

Sam

Re: Join Problem

sasiparupudi1 — Tue, 25 Aug 2015 07:28:17 GMT

qualify *;

SQL SELECT

Key1,

Data1,

Data2

FROM A;

LEFT JOIN(A)

SQL SELECT

Key1,

Data3

FROM B;

noconcatenate

FINAL:

load * resident A where A.Key1=B.Key1;

drop table A;

Re: Join Problem

k_burata — Tue, 25 Aug 2015 08:09:28 GMT

Hi Sasidhar,

It seems like it works as an inner join and not a left join.

It doesn'y show all the records from table A.

Regards,

Re: Join Problem

sasiparupudi1 — Tue, 25 Aug 2015 08:11:15 GMT

then try

SQL SELECT

Key1,

Data1,

Data2

FROM A;

LEFT JOIN(A)

SQL SELECT

Key1,

Data3

FROM B;

Re: Join Problem

k_burata — Tue, 25 Aug 2015 08:31:49 GMT

Thanks Sasidhar.