Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have one query regarding applymap.
I have one table qvDirectSales_JDE which contain data for US and Canada,where for canada data I have to replace field data with some other field from other table with the help of Applymap.
Step 1)
qvDirectSales_JDE qvd has 2 fields [_%ERP_Customer#_Key] and Country.
IIF Country = Canada then replace [_%ERP_Customer#_Key] with ERPCustomer_ID field from qvNACustomerRollUp_BARD Qvd.
Joining condition between this 2 table is
qvNACustomerRollUp_BARD->BARD_Parent_ID
qvDirectSales_JDE->[_%ERP_Customer#_Key]
But both the keys are not exactly in same order so we have to convert them .I have prepared the script but it is half work.So For US Country Keep [_%ERP_Customer#_Key] as it is ,but for canada bring ERPCustomer_ID from qvNACustomerRollUp_BARD on the basis of BARD_Parent_ID Key.And in this this case I have to handle this with the help of Applymap.
Please help me on this.
Regards,
Rupali Ethape
I guess I understand what you are saying, but where have you tried ApplyMap in the attached app? What field/s are you doing this ApplyMap on? What is the issue you run into when you do the ApplyMap?