This Content is from Stack Overflow. Question asked by Frank Lohfeld
i will in an Azure Synapse Dataflow, for every row that field value in Column “Name” Starts with “F-” synapse should change the value from Column “Price” to a absolute Value of the price.
Which Mapping data flow transformation can i use and which expression i must use?
I have tryed the “alter Row” transformation but i couldn’t get the expression done.
SORRY I’m a absolut beginner
| Name | Price |
| P-12344 | -21354,45|
| S-12335 | 12543,45|
| F-13564 | 54,45|
| F-112344 | -1254,45|
THANKS IN ADVANCED
You can use derived column transformation and
abs() function in data flow.
Please go through the sample demonstration below:
I have given String type to Name column and integer type to Price column in the projection of the source.
Derived column transformation:
Give the below expression
Result in Data preview:
You can give the same source in the sink.
This Question was asked in StackOverflow by Frank Lohfeld and Answered by Rakesh Govindula It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.