ApplyMap

rupaliqlik — Mon, 18 Feb 2019 18:17:27 GMT

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

Re: ApplyMap

sunny_talwar — Tue, 19 Feb 2019 12:21:26 GMT

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?

topic Re: ApplyMap in QlikView

ApplyMap

Re: ApplyMap