'Azure Data Factory Dataflow trouble with ToDecimal

Im kinda new with ADF so thats why im struggling with the following task:

My source file is a csv file and has a column TotalCost and TotalSales. These columns has a string type. In My destionation sql table i would like to change this to a decimal type. This is the expected output in the destination table.

enter image description here

When i use the Dataflow task Derived Column, i use the Expression builder in order to change the type String to Decimal.

In the expression builder i used the toDecimal (TotalCost).

After running the dataflow in ADF i get the following result in the destination table:

enter image description here

As you can see NULL values are returned because some records from picture 1 has a decimal value.

i assumed that toDecimal (TotalCost) is not the right expression. Any suggestion? Many thanks for your time.

azureexpressiondecimalfactorydataflow


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions