Assign multiple values to Null value field IN Azure data factory

Question

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

Answer 1

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.