topic Re: Selecting Multiple tables and left join with only one table in QlikView

Selecting Multiple tables and left join with only one table

Smeenakshi23 — Sat, 16 Nov 2024 01:31:18 GMT

Hello,

I am sorry for this question.. I know this is a basic one. But couldn't implement, as I just started learning development.

I have a SQL select statement in QLikview

Ex:

Select

all the tables

from

table A
table B
table C
Table D

WHERE CONDITION

FILED 1.TABLE A = FILED1.TABLE B

FILED 2.TABLE B = FIELD2.TABLE B

and other linking conditions

GROUP BY FILEDS in all the tables

I need to use left join the table B with Table A.

i am not pretty sure to implement this as it has group by and where clause

Re: Selecting Multiple tables and left join with only one table

Stoyan_Terziev — Tue, 14 Jan 2020 09:41:49 GMT

Hi Sowmiya,

The result of your demo query would be a single table which has already pre-joined the tables using standard SQL.

Doing that would look like:

Select A1.DataKey, A1.Data2, B1.Data1 FROM TABLEA A1 LEFT JOIN TABLEB B1 ON A1.DataKey = B1.DataKey

If you want to do the join in QlikView:

TableA: LOAD DataKey, Data2 ; Select DataKey, Data2 FROM TABLEA ; LEFT JOIN (TableA) LOAD DataKey, Data1 ; Select DataKey, Data1 FROM TABLEB ;

Re: Selecting Multiple tables and left join with only one table

Smeenakshi23 — Tue, 14 Jan 2020 10:26:15 GMT

Sorry If my question wasnt clear. I need to join within a table.. I believe now the mentioned where condition does eqi join.. I wanted to change that to inner join.

Re: Selecting Multiple tables and left join with only one table

Smeenakshi23 — Tue, 14 Jan 2020 10:27:03 GMT

Wanted to change that to a left join

Re: Selecting Multiple tables and left join with only one table

Stoyan_Terziev — Tue, 14 Jan 2020 12:36:43 GMT

Hi,

Can you export to excel the content of each table (or a data sample) and show me how you would like the end result to look like.

Keep in mind, to change the type of joins, you can practically change the word 'LEFT' in the code I sent you with 'INNER/OUTER/RIGHT' if you need.

Check here some explanation about joins you can find useful: https://www.edureka.co/blog/sql-joins-types

Kind regards,

S.T.

Re: Selecting Multiple tables and left join with only one table

Smeenakshi23 — Sat, 18 Jan 2020 04:58:32 GMT

Hello, I tried this and the qlikview is getting hung.. Actually, my first table called employee inner join with one of the table called sales.. so wen there is no sale data.. all my first emlloyee table fields as excluded.. so even wen there is no value in sale table , my employee table needed to show the values.

AS of in the previous script there is where clause instead of inner join.. I need to change that to a left join.

Also , followed by employee table there are many tables that get inner joined ..

Re: Selecting Multiple tables and left join with only one table

Brett_Bleess — Tue, 11 Feb 2020 21:53:22 GMT

You can also check out the Design Blog area of Community:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are over 700 posts there from our internal experts and most are how-to related, so should prove useful in trying to get ideas on how to approach things.

Regards,
Brett