combine derived column expression

Question

in dataflow I am using a derivedColumn_1 with the following expression:

replace(Column_1, '},"additionalDetails"', '}],"additionalDetails"')

in derivedColumn_2 with the following expression:

replace(Column_1, '},"company"', '}],"company"')

question,

is it possible to put both of the above into one derived column expression?

thanks

Answer 1

Hello @arkiboys

Does your source data looks like the below one ? and you want to update the incoming data by using one expression?

Did you try to use the replace function in the same expression twice?

Something like:

replace(replace(Column_1, '},"additionalDetails"', '}],"additionalDetails"'), '},"company"', '}],"company"')