Share via

Multiple conditions in data flow derived column

Krishnamohan Nadimpalli 406 Reputation points
2023-07-25T08:56:27.4633333+00:00

Hi

I have a column called p_creative. I need to do multiple operations like replace new line character with spaces , replace comma(,) with spaces, ltrim etc., How do I achieve this in a single derived columns

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,429 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. QuantumCache 20,356 Reputation points
    2023-07-25T21:38:01.54+00:00

    Hello @Krishnamohan Nadimpalli

    Did you try any expression in the Derived column in the Dataflow ?

    Please let us know any sample data in the input column, so that we try to repro the same and help you!!!

    For example, the below removes the special characters from the column data.

    ltrim(replace(replace(YourColumn, '\n', ' '), ',', ' '))

    User's image

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.