topic Please help me in using applymap function. in QlikView

Please help me in using applymap function.

durgabhavani — Fri, 11 May 2018 11:51:09 GMT

Hi All,

I am looking to map the values to empid in existing table using mapping file using applymap function .

My existing table

Mapping file:

Expected Output:

Please advice.

Miguel_Angel_Baeyens — Fri, 11 May 2018 12:00:58 GMT

Replied in your other post.

isingh30 — Fri, 11 May 2018 13:13:39 GMT

May be like this -

Temp:

mapping LOAD Empid,

Country

FROM

(ooxml, embedded labels, table is Sheet2);

Temp2:

load*,

applymap('Temp',Empid,null()) as Country

FROM

(ooxml, embedded labels, table is Sheet1);