databricks spark XML Writer

RobsonNLPT
Contributor III

‎02-07-2024 08:26 AM - edited ‎02-07-2024 08:30 AM

Hi.

I'm trying to generate XML as output base on my nested dataframe. Everything is ok except by I don't know how to add elements to rootTag.

I can add elements from rowtag but not in rootTag. Same problems to add attributes to root 

<books  version = "5.2">
 <library>"LIB1"</library>
 <book id="bk103">
  <author>Corets, Eva</author>
  <title>Maeve Ascendant</title>
 </book>
 <book id="bk104">
  <author>Corets, Eva</author>
  <title>Oberon's Legacy</title>
 </book>
</books>

any help?

 

 

 

Ayushi_Suthar
Databricks Employee
Databricks Employee

‎02-10-2024 05:02 AM

Hi @RobsonNLPT ,Thanks for bringing up your concerns, always happy to help 😁

Can you please refer to the below document to read and write the XML files?

https://docs.databricks.com/en/query/formats/xml.html

Please let me know if this helps and leave a like if this helps, followups are appreciated.
Kudos
Ayushi

 

0 Kudos

RobsonNLPT
Contributor III
In response to Ayushi_Suthar

‎02-10-2024 06:58 AM

Hi Ayushi.

I've checked all official documentation. 

There's no support for rootTag elements and optional rootTag/rowTag

 

 

0 Kudos