Convert Join from Full Outer to Inner

[zahidrahim_ocp]

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

[tresesco]

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

Table1:

....

Inner Join

Table2:

....

[zahidrahim_ocp]

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_Amarneh]

can you give example, your question is not clear !

[Anil_Babu_Samineni]

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

[pradosh_thakur]

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 .

[zahidrahim_ocp]

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]

try this

Table1:

Load Id,

Name,

Trdate

FROM tbl1

WHERE Trdate >'01/01/2017';

inner keep

Table2:

Load Id,

Address

from tbl2;

[marcus_sommer]

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_Amarneh]

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;