Converting Dataframe into Nested xml

[PriyaTech]

e.g.

dataframe is having firstname,lastname,middlename,id,salary

I need to convert dataframe in xml file but in nested format.

output as nested xml

<Name>

    <firatname>

<middlename>

    <lastname>    

</Name>

<id></id>

<salary></salary>

Anyone has ides hot to achieve this.

[-werners- · Accepted solution]

databricks has a xml connector:

https://docs.databricks.com/data/data-sources/xml.html

Basically you just define a df with the correct structure and write it to xml.

To create a nested df, here you can find some info.