Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure if I understood right. May be just replace join with inner join, like:
Table1:
....
Inner Join
Table2:
....
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.
can you give example, your question is not clear !
You should use them to rid the automatic join like he mentioned
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 .
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.
try this
Table1:
Load Id,
Name,
Trdate
FROM tbl1
WHERE Trdate >'01/01/2017';
inner keep
Table2:
Load Id,
Address
from tbl2;
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
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;