Hi, I am trying toprform an applyma function where i wanted to bring one date field from one table to another. Here i am attaching two excel files of sample data in which i would like to Bring the Product_Birth field from mapping table to original data table based on the common keys.
Here we have two common keys
1) Material(Data file). Name(Mapping File)
2)Material_Key_New(data file). ProductCode(Mapping file)
I have tried to do an apply map using the two common keys seperately but could not get succeed. It is not shpwing any data except for nulls. I could not find any error in it.
Kindly help with this scenrio
Please post the script that shows where you load the mapping tables and the applymap(). Or post a sample app if you can.
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
//Applymap('Mapping1',Material,Null()) as New_Code,
//Applymap('Mapping2',Material_Key_NEW,Null()) as New_Lable,
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.