Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two tables,
Table A
ID,
ITEM
Table B
ITEM,
Cost
Now I want to load table C which has ID and cost fields. Something like:
TableC:
Load
ID,
Cost
from resident A,B?
TableC:
Noconcatenate Load * resident TableA;
OUTER JOIN (TableC) LOAD * resident TableB ;
Drop Tables TableA , TableB ;
You can try with simple Join
TableA:
Load
ID,
ITEM
From Location;
Join(TableA)
TableB:
Load
ITEM,
Cost
From Location;
Noconcatenate
TableC:
Load
ITEM,
ID,
Cost
Resident TableA;
Drop Table TableA;
That's depending on your data on what you want to analyze.
If it's just a kind of lookup, so it's either one ID per ITEM and / or one Cost value per ITEM, you can also use a MAPPING approach instead of a JOIN:
http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap
But it's hard to suggest anything without knowing your data structure.