lundi 21 décembre 2020

IF expression in Azure Data Factory

I have a JSON file which is being used as a data source.

My issue right now is when I was trying to map the data into a CSV file, I noticed that the column documentConfigId has some values which are within an object and some which are not: (example below)

Without

"documentConfigId":{
"12345678"
}

With

"documentConfigId":{
"$ref": "12345678"
}

Is there any way that I can create a dynamic content which will use the first mapping solution for rows which do not have the inner reference node, but when it does have it, it should use the second solution.

enter image description here

This is what it currently shows in Excel when I just use the first mapping solution.

enter image description here

3 commentaires: