2 Replies Latest reply: Jul 15, 2016 12:45 PM by Sunny Talwar RSS

    Applymap always fails

    walter coleman

      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