replace expression

Question

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"')

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

Thank you

Answer 1

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.

https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-expression-builder#locals