Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
How to flatten XML document using azure dataflows allowing for schema drift?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 27%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUF%3C/text%3E%3C/svg%3E)
Uffe Friis Torlyn
1
Reputation point
I have a simple XML document looking like the below. However the tags within "Point" can change and other tags can added in the future.
I need to unfold/flatten the file at "Point".
I have tried numerous of things included tryind to derived "Point" as a column like this:
byItem(byName('ns0:HistoricalActivation_MarketDocument'),"ns0:Point")
]2
And I have also tried to unfold it directly using this:
![215367-image.png][3]
Niether works. Any suggestions?
XLM file example
<ns0:HistoricalActivation_MarketDocument xmlns:ns0="urn:iec62325.351:tc57wg16:451-7:historicalactivationdocument:6:0" xmlns:cl="urn:entsoe.eu:wgedi:codelists">
<ns0:Point>
<ns0:position>1</ns0:position>
<ns0:quantity>0</ns0:quantity>
</ns0:Point>
<ns0:Point>
<ns0:position>2</ns0:position>
<ns0:quantity>0</ns0:quantity>
</ns0:Point>
</ns0:HistoricalActivation_MarketDocument>
Azure Data Factory
{count} votes
-
MarkKromer-MSFT 5,231 Reputation points Microsoft Employee Moderator2022-06-28T17:01:23.477+00:00 Can you try wrapping your string inside the byName() inside toString()?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator2022-07-06T17:29:41.18+00:00 Hello @Uffe Friis Torlyn ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu -
Uffe Friis Torlyn 1 Reputation point
2022-07-18T12:38:26.873+00:00 Hi Mark. I have tried it - Same result
Sign in to comment
Sign in to answer