Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

k_burata
Contributor

Join Problem

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

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Join Problem

then try

A:

SQL SELECT

     Key1,

     Data1,

     Data2

FROM A;

LEFT JOIN(A)

B:

SQL SELECT

     Key1,

     Data3

FROM B;

5 Replies
mightyqlikers
Contributor III

Re: Join Problem

hi Kim,

use alias in sql query itself.

Regards

Sam     

sasiparupudi1
Honored Contributor III

Re: Join Problem

qualify *;

A:

SQL SELECT

     Key1,

     Data1,

     Data2

FROM A;

LEFT JOIN(A)

B:

SQL SELECT

     Key1,

     Data3

FROM B;

noconcatenate

FINAL:

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

drop table A;

k_burata
Contributor

Re: Join Problem

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,


sasiparupudi1
Honored Contributor III

Re: Join Problem

then try

A:

SQL SELECT

     Key1,

     Data1,

     Data2

FROM A;

LEFT JOIN(A)

B:

SQL SELECT

     Key1,

     Data3

FROM B;

k_burata
Contributor

Re: Join Problem

Thanks Sasidhar.

Community Browser