Forum Discussion

Hitesh_Sri's avatar
Hitesh_Sri
Copper Contributor
May 06, 2022

Mapping of XML file in Azure Data Factory

Hey,

I'm trying to do mapping of XML file from HTTP connector in Azure Data Factory, now the issue is that in a single column some rows are there as an Object and others as a node.

1st screen shot

2nd screen shot

 

Here, in 1st screen shot the customer-work-region is an object and in the another one it is a node.

If we do the mapping according to one case, then we get an error and if we select "Skip Incompatible Rows"  we are loosing some data.

So is there any other way by which we can get data without any data loss?

No RepliesBe the first to reply

Resources