Share via

replace expression

arkiboys 9,711 Reputation points
2022-03-30T15:16:11.953+00:00

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

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

Answer accepted by question author

MarkKromer-MSFT 5,231 Reputation points Microsoft Employee Moderator
2022-03-31T04:48:41.267+00:00

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

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.