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: 
rupaliqlik
Creator
Creator

ApplyMap

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.

 kaushik.solanki ,stalwar1‌ 

 

Regards,

Rupali Ethape

 

1 Reply
sunny_talwar

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?