Mapping of XML file in Azure Data Factory

Occasional Contributor

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

Hitesh_Sri_0-1651837980510.png

2nd screen shot

Hitesh_Sri_1-1651837991454.png

 

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.

Hitesh_Sri_2-1651838827410.png

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

0 Replies
www.000webhost.com