Data Integration with conditional factoring of the data/amount column
Content:
We load multiple accounts worth of data, value-based and score-based. Both accounts come from the same csv-file and have the same formatted amounts, however score-based accounts should be percentages. Meaning that the value I receive equals 80. But should be 80% or 0.80. Now, I know that we can use the factor source expression in integrations to change this. However, this changes all accounts. Also the accounts where I would like to take 80 as 80 (valued-based).
Is there something like conditional factor in the dimension mapping for such a case? Or any other good suggestion within Data Exchange. Excluding loading the file twice through Pipelines or something like that.