topic Re: Mapping load in QlikView

Mapping load

siva0606 — Mon, 21 Jan 2013 05:42:53 GMT

Does mapping load requires two columns of data? Is it necessary?

Re: Mapping load

er_mohit — Mon, 21 Jan 2013 05:52:57 GMT

the purpose of using mapping load is to drop one field of one table to other table

for this in two tables you have must one primary key then using mapping load,

load 1st field which is primary key to both table and through that field load another field which you want to drop it in another table while execution...

Re: Mapping load

Mon, 21 Jan 2013 07:10:14 GMT

the concept of mapping table is that,

the mapped table(table1) have atleast two column(field name), 1st column must be primary key and on the basis of it we mapped the 2nd column from table2.

primary key must be common in both table.

example--

mapping load

productid,

productname from table1;

load orderid,

item,

quantity,

productid

Applymap('table1',productid) as productname

from table2;

hope this helps you.