topic Re: Applymap always fails in QlikView

Applymap always fails

Fri, 15 Jul 2016 16:28:59 GMT

Something is not set correctly. Attempting to add a field from one table to another which will end as the main fact table. Adding this field will enable me to do further rate calculations.

I tried a left join initially but it increased the record count so i went to a applymap logic.

I'm attempting to insert the FXRate so that i can do some further calculations in the main fact CustomerFX which is missing the FXRate field in the initial Customer table.

Thanks in advance

Re: Applymap always fails

sunny_talwar — Fri, 15 Jul 2016 16:42:32 GMT

Can you try this:

CustomerFX:

LOAD

ApplyMap('Currency_map',Num(ID, '00')&'|'&YEAR&'|'&CURRENCY, 'Unknown') as NewlyAddedFX_Rate,

ID as IDFX,

CUST as CUSTFX,

CURRENCY as CURRENCYFX,

MONTH as MONTHFX,

YEAR as YEARFX,

AMOUNT

RESIDENT Customers;

Re: Applymap always fails

sunny_talwar — Fri, 15 Jul 2016 16:45:55 GMT

Attaching back the application