How to handle different XML file with different namespace for same element in Fabric pipeline
Sethulakshmi Sambasivan
45
Reputation points
I have multiple XML files with same data with different name space, so while performing the copy activity using pipeline its skipping records or not all copying anything. pipeline is not throwing any error, running successfully populating the table with blanks.
ample file1:
<ns7:Items>
<ns6:itemdetails>
<ns6:ID>123</ns6:ID>
<ns6:item>apple</ns6:item>
</ns6:itemdetails>
<ns6:itemdetails>
...................................
</ns6:itemdetails>
</ns7:Items>
sample file2:
<ns7:Items>
<ns3:itemdetails>
<ns3:ID>124</ns6:ID>
<ns3:item>orange</ns6:item>
</ns3:itemdetails>
</ns7:Items>
How to handle when there are different namespace for same elements inside pipeline or is there any other method to handle these kind a files?
Sign in to answer