Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
zahidrahim_ocp
Contributor

Convert Join from Full Outer to Inner

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

9 Replies
MVP
MVP

Re: Convert Join from Full Outer to Inner

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

Table1:

....

Inner Join

Table2:

....

zahidrahim_ocp
Contributor

Re: Convert Join from Full Outer to Inner

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.

yousef_am
Contributor II

Re: Convert Join from Full Outer to Inner

can you give example, your question is not clear !

Re: Convert Join from Full Outer to Inner

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

Life is so rich, and we need to respect to the life !!!
pradosh_thakur
Honored Contributor II

Re: Convert Join from Full Outer to Inner

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 .

Learning never stops.
zahidrahim_ocp
Contributor

Re: Convert Join from Full Outer to Inner

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.

pradosh_thakur
Honored Contributor II

Re: Convert Join from Full Outer to Inner

try this

Table1:

Load Id,

Name,

Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

inner keep

Table2:

Load Id,

Address

from tbl2;

Learning never stops.

Re: Convert Join from Full Outer to Inner

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

yousef_am
Contributor II

Re: Convert Join from Full Outer to Inner

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;

Community Browser