What is the best way to load two fields from two individual tables

[#1]

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?

[patricio]

TableC:

Noconcatenate Load * resident TableA;

OUTER JOIN (TableC) LOAD * resident TableB ;

Drop Tables TableA , TableB ;

[its_anandrjs]

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;

[swuehl]

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.