topic Re: How to map the data from existing table in QlikView

How to map the data from existing table

rkpatelqlikview — Fri, 16 Feb 2018 09:06:30 GMT

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.

Re: How to map the data from existing table

YoussefBelloum — Fri, 16 Feb 2018 09:20:52 GMT

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

Re: How to map the data from existing table

vineetadahiya12 — Fri, 16 Feb 2018 09:23:28 GMT

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.

Re: How to map the data from existing table

rkpatelqlikview — Fri, 16 Feb 2018 09:40:41 GMT

Thanks for your response.

Please find the attached.

Re: How to map the data from existing table

rkpatelqlikview — Fri, 16 Feb 2018 09:41:53 GMT

Thanks Youssef,

Please find the Attached.