How to map the data from existing table

[rkpatelqlikview]

Hi All,

Can any one please help on this? Please find the attached sample data

There are tables with same field names but with records. there is one Field with same records. In field Estore there is no records from one table, its N/A. Another table Estore is having records. I need to map that records into N/A records.

How can i achieve this.??

Thanks in advance.

[YoussefBelloum]

Hi,

For each Vnum from Sheet1 table, you need to map the Estore value to Sheet2 ?

Mapping_table:

Mapping LOAD

Vnum,

    Estore

FROM

(ooxml, embedded labels, table is Sheet1);

Table2:

LOAD Date,

    ApplyMap('Mapping_table',Vnum,'N/A') as Estore,

    Vnum

FROM

(ooxml, embedded labels, table is Sheet2);

Please find attached

[vineetadahiya12]

Can you explain more how you want to show your final table in qlikview application. Your question is not clear to provide with any help.

[rkpatelqlikview]

Thanks for your response.

Please find the attached.

[rkpatelqlikview]

Thanks Youssef,

Please find the Attached.