Please help me in using applymap function.

[durgabhavani]

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:

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

Expected Output:

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

Please advice.

[Miguel_Angel_Baeyens]

Replied in your other post.

[isingh30 · Accepted solution]

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