How to get a separate table after Joining Tables in Qlikview

[arunqlik2view]

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,

[lfholland]

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.

[neelamsaroha157]

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.

[MarcoWedel]

please post some sample data for tables 1 and 2 and you required result.

thanks

regards

Marco

[vamsee]

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;

[arunqlik2view]

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;