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

[vishalmanu]

Test

[vishalmanu]

Sorry, forgot to attach another file

[rwunderlich]

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]

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]

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

[vishalmanu]

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]

Not sure how it handles mixed formatting in the field

[rwunderlich]

material_key_new is an existing field in the QVD?  

[vishalmanu]

Yes. It already exists

[CarlosAMonroy]

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