Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalmanu
Creator
Creator

Unable to Map a field from one able to another using applymap

Test

Labels (3)
15 Replies
vishalmanu
Creator
Creator
Author

Sorry, forgot to attach another file

rwunderlich
Luminary Alumni
Luminary Alumni

Please post the script that shows where you load the mapping tables and the applymap().  Or post a sample app if you can. 

-Rob

vishalmanu
Creator
Creator
Author

Hello rob,

 

Please find the below the script that  i have used. Kindly note that i have used two apply map functions to check the feasibility of the Applymap functions based on two diff common keys.

 

Kindly look into this and provide me a solution

 

Lisa_P
Employee
Employee

I can't find any matching values in the data.
vishalmanu
Creator
Creator
Author

Hello Lisa

There are matching values between in the fields productcode from the mapping table to material_key_new in the origin table
Lisa_P
Employee
Employee

Not sure how it handles mixed formatting in the field

rwunderlich
Luminary Alumni
Luminary Alumni

material_key_new is an existing field in the QVD?  

vishalmanu
Creator
Creator
Author

Yes. It already exists
CarlosAMonroy
Creator III
Creator III

Hey Vishalmanu,

I did not download your sample files, but if you're trying to map 'Dates', it's important that you make sure both date formats from source to target table are the same. If you are getting nulls values, this could be the reason.

 

Thanks,

Carlos M