This content has been marked as final. Show 2 replies
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