Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalmanu
Partner - Creator
Partner - Creator

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

Test

Labels (3)
15 Replies
vishalmanu
Partner - Creator
Partner - Creator
Author

Sorry, forgot to attach another file

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Creator
Partner - 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
Partner - Creator
Partner - 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
Partner Ambassador/MVP
Partner Ambassador/MVP

material_key_new is an existing field in the QVD?  

vishalmanu
Partner - Creator
Partner - 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