I am relatively new to the ADF, I am trying to achieve following: Have csv file:

I am relatively new to the ADF, I am trying to achieve following: Have csv file:

I need to apply to both "new price" cells following function: if(A2>1000, A2*1.3, if(A2<100, A2*1.1, A2*1.2))

It easy to do in Excel, but I can not find the way how to do it in Azure Data Factory f. e. Data Flow...

I used "Derived Column" data flow and tried different expressions as well as different data types in Column A but all produced "Type Mismatch", "Expression type could not be evaluated type error.

• azure
• azure-data-factory
• expression
• oracle-adf

• I found resolution by myself. – Michael Graber - NOAA Affiliat Commented Mar 24 at 17:58

1 Answer 1

"Type Mismatch", "Expression type could not be evaluated type error. If the price column in ADF is stored as a string, it must be converted to a numeric type using toDecimal(price) to enable accurate arithmetic operations. Failure to perform this conversion may result in a type mismatch error.

1. Please use the following expression to achieve the desired results

iif(toDecimal(price) >  1000, toDecimal(price) *  1.3,
   iif(toDecimal(price) <  100, toDecimal(price) *  1.1,
   toDecimal(price) *  1.2))

2. Based on the sample data you provided; I have proceeded accordingly.

3. I have provided the following expression for use in the derived column as required.

iif(toDecimal(price) >  1000, toDecimal(price) *  1.3,
   iif(toDecimal(price) <  100, toDecimal(price) *  1.1,
   toDecimal(price) *  1.2))

4. Output is as expected as per your requirement.