Hi @Sampath S
With just a copy activity it's not possible to replace multiple strings with null.
We either have to use azure functions or batch to replace strings.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In ADF, If i select source as xml api or excel input/file input. There is a field called Null Value. I want to insert multiple values to that field. How Can I do that?
Example: I want to make the input string to null whenever 'xyz' or 'pqr' comes. if i add xyz alone it will convert that string to null, But i am not able to check(convert) both the strings to null from the input at the same time
Input
[{
"captain":{
"row":[
{
"@DeezNutz ": "carlo",
"@runs":50.0,
"@myworld ": pqr,(target -double)
"@MOS ": xyz(target-double)
},
{
"@DeezNutz ": "David ",
"@runs":500.0,
"@myworld ":5,
"@MOS ":1
}
]
}
}
]
Expected Op It should update db table with 2 rows
Op which I got:Copy data activity cannnot convert pqr to double
Hi @Sampath S
With just a copy activity it's not possible to replace multiple strings with null.
We either have to use azure functions or batch to replace strings.