question

MafaldaSampaioAmorimdeSousaOliveir-1402 avatar image
0 Votes"
MafaldaSampaioAmorimdeSousaOliveir-1402 asked HimanshuSinha-MSFT commented

How can I replace attributes values using azure data factory?

For example, I have a value that is = corretiva and I want to change it to = 1

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MafaldaSampaioAmorimdeSousaOliveir-1402 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello @MafaldaSampaioAmorimdeSousaOliveir-1402 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

1 Answer

MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered

Add a data flow to your pipeline. Add a source that points to your data, then add a Derived Column. Pick the column name you wish to change and then set the value you wish to set it to using the Expression Builder. https://docs.microsoft.com/en-us/azure/data-factory/data-flow-derived-column

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.