Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
siva0606
New Contributor II

Mapping load

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

2 Replies
er_mohit
Honored Contributor II

Re: Mapping load

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...

Not applicable

Re: Mapping load

hi

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.

Community Browser