replace expression

arkiboys 9,186 Reputation points

At present in dataflow1, there are two derived columns
derivedcolumn1 : Column_1 --> replace(Column_1, '"address":{', '"address":[{')
derivedcolumn2: Column_1 --> replace(Column_1, '},"office"', '}],"office"')

Is it efficient to have these two derivedcolumns into one derived column instead?
If so then how is that done please?

Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,472 questions
{count} votes

Accepted answer
  1. MarkKromer-MSFT 5,171 Reputation points Microsoft Employee

    No real difference in terms of performance or efficiency.

    The way you would achieve that is to create a local variable from the expression builder and address that new local variable in your expression.

    0 comments No comments

0 additional answers

Sort by: Most helpful