Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Please help me in using applymap function.

Hi All,

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

My existing table

   

Empid
101
102
103
104
105
106
107
108
109
110

Mapping file:

   

EmpidCountry
101us
102India
103Srilanka
104pak
105aus
106uk
107uk

Expected Output:

   

EmpidNew_Country
101us
102India
103Srilanka
104pak
105aus
106uk
107uk

Please advice.

1 Solution

Accepted Solutions
isingh30
Specialist
Specialist

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);

Capture.PNG

View solution in original post

2 Replies
Miguel_Angel_Baeyens

Replied in your other post.

isingh30
Specialist
Specialist

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);

Capture.PNG