Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to join Table1 (main data table) with Table2 ( reference look up table ) in qlikview and I want the resulting table in Table3 but qlikview makes changes in the Table1 itself, which I don't want
Current code used in Qlikview
inner Join(Table1)
North:
LOAD Partnumber,
Region
FROM
(biff, embedded labels, table is Sheet1$) ;
Please advice on this regard.
Thanks in Advance,
Try not doing the join. If you have a field in your "North" table that is the same name as a field in your "Table 1" they will still be linked together.
the changes are being made to your initial table because of the inner join.
If you want table1 ,2 separately and the inner join results in 3rd table then you may try this -
Noconcatenate
Load *
from Table1 ;
noconcatenate
Load *
from Table2;
Table3:
noconcatenate Load * resident table1;
inner join Load * resident table2;
Rename the fields in table3 leaving out the key fields else it will create a synthetic key.
please post some sample data for tables 1 and 2 and you required result.
thanks
regards
Marco
I think you are looking for keep.
Use Keep instead of Join
https://www.tutorialspoint.com/qlikview/qlikview_keeps.htm
Inner Keep(Table1)
Load *
From Table2;
Hi , Thanks for the reply , I'm still breaking my head on this ,
I tried your method but I get error for resident table2; , Please let me know what am I doing wrong .
noconcatenate
Load *
from Table1 ;
noconcatenate
Load *
from Table2;
Table3:
noconcatenate Load * resident table1;
inner join Load * resident table2;