topic Re: Convert Join from Full Outer to Inner in QlikView

Convert Join from Full Outer to Inner

zahidrahim_ocp — Thu, 04 Jan 2018 07:02:40 GMT

Dear Experts,

We all know two tables joined as Full Outer Join on same field name. Can we convert that full outer join to inner join without removing the table from data model?

Regards,

Zahid Rahim

Re: Convert Join from Full Outer to Inner

tresB — Thu, 04 Jan 2018 07:05:16 GMT

Not sure if I understood right. May be just replace join with inner join, like:

Table1:

....

Inner Join

Table2:

....

Re: Convert Join from Full Outer to Inner

zahidrahim_ocp — Thu, 04 Jan 2018 07:08:17 GMT

There is no Join mentioned. Only Two Table which join automatically through same field names using default full outer join. I want to join them using Inner Join.

Re: Convert Join from Full Outer to Inner

Yousef_Amarneh — Thu, 04 Jan 2018 07:14:35 GMT

can you give example, your question is not clear !

Re: Convert Join from Full Outer to Inner

Anil_Babu_Samineni — Thu, 04 Jan 2018 07:17:00 GMT

You should use them to rid the automatic join like he mentioned

Re: Convert Join from Full Outer to Inner

pradosh_thakur — Thu, 04 Jan 2018 07:19:20 GMT

first of all when you dont use the key word join Qlikview associate them as per the common field name . The Association is not a outer join but can be comparable to outer join at run time or in other words when you select anything in the filter it will show all the associated value in the model.

Not sure i understand your requirement but May be you need a inner keep between the tables if you want to keep both the table .

Re: Convert Join from Full Outer to Inner

zahidrahim_ocp — Thu, 04 Jan 2018 07:28:34 GMT

Example:

Table1:

Load Id,

Name,

Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

Table2:

Load Id,

Address

from tbl2;

Now i want to join them as inner so that Table2 should not get irrelevant data.

Re: Convert Join from Full Outer to Inner

pradosh_thakur — Thu, 04 Jan 2018 07:31:39 GMT

try this

Table1:

Load Id,

Name,

Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

inner keep

Table2:

Load Id,

Address

from tbl2;

Re: Convert Join from Full Outer to Inner

marcus_sommer — Thu, 04 Jan 2018 07:36:02 GMT

You need to do it explicitely within the script maybe with an inner keep between both tables or probably more common with a where-clause on your second load, for example:

Table1:

Load Id,

Name,

Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

Table2:

Load Id,

Address

from tbl2 where exists(Id);

- Marcus

Re: Convert Join from Full Outer to Inner

Yousef_Amarneh — Thu, 04 Jan 2018 07:38:05 GMT

If you want to keep both tables, so at the end you will have 2 tables use keep

Table1:

Load Id, Name, Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

inner keep

Table2:

Load Id, Address

from tbl2;

but if you want to merge them in 1 table use join

Table1:

Load Id, Name, Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

inner join

Table2:

Load Id, Address

from tbl2;