Regarding applymap function in QlikSense

[skiruthigadevi]

Hello Folks,

Appreciate your time.

I am trying to do an applymap in a portion of my field.

for eg, I have a field called Report_Vendor_Prodid which has value 7|ABC|123 ,

I would like to swap the prodid with  product category. let say the above prodid belongs to  product category 1 then my result would like some thing below

7|ABC|1

could you kindly let me know your feedback.,thank you!

Kiruthiga

[Gui_Approbato]

Hello,

You need to load the mapping table prior to the data table, with the "mapping" argument.

Then, in your data table you use the Applymap with the name of your mapping table.

It would be something like this:

Mymap:

Mapping Load * Inline [

From , To

123 , 1

x , y ] (delimiter is ',') ;

Data:

Load Column1,Column2, Applymap('MyMap', Prodid) as Category , ... from..;

 Your mapping table must contain only 2 columns.