Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
Thanks for your response.
Please find the attached.
Thanks Youssef,
Please find the Attached.