cancel
Showing results for 
Search instead for 
Did you mean: 
Community Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

databricks spark XML Writer

RobsonNLPT
Contributor

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?

 

 

 

2 REPLIES 2

Ayushi_Suthar
Honored Contributor
Honored Contributor

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

 

Hi Ayushi.

I've checked all official documentation. 

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

 

 

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.