Joining two resident tables

[#1]

I have tow tables with information of which I want to multiply a value from table 1 with a value from table 2 and store it in table 3.

First table
%ITM ,
TTYPE,
TQTY

Second table

DOCO,
%ITM,
QTY

I want to multiply QTY with TQTY and store this in a third table

table 3

DOCO,
SERVICE,
SCOST

Second.DOCO = DOCO
first.TTYPE = SERVICE
TQTY.QTY = SCOST

I dont know how to load info from 2 resident tables.

Who can help me

[#2]

First:

Load %ITM,

TTYPE as SERVICE,

TQTY from FirstTable;

left join(First)

load %ITM,

DOCO,

QTY

from secondTable;

Table3::

load DOCO,

SERVICE,

TQTY * QTY as SCOST

resident first;

Does that helps ?

Philippe

[#3]

I think the previous solution will works well

You also can do it with apply map :

http://community.qlik.com/forums/p/16017/62222.aspx#62222

Regards