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.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. QuantumCache 20,676 Reputation points Moderator
    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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.