topic Joining two resident tables in QlikView

Joining two resident tables

Wed, 05 Aug 2009 20:56:26 GMT

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

Wed, 05 Aug 2009 22:36:15 GMT

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

Wed, 05 Aug 2009 22:54:08 GMT

I think the previous solution will works well

You also can do it with apply map :

Regards