Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Applymap always fails

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

2 Replies

Re: Applymap always fails

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

Attaching back the application

Capture.PNG

Community Browser