Applymap always fails

[#1]

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

[sunny_talwar]

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;

[sunny_talwar]

Attaching back the application