topic Converting Dataframe into Nested xml in Data Engineering https://community.databricks.com/t5/data-engineering/converting-dataframe-into-nested-xml/m-p/30708#M22292 <P>e.g.</P><P></P><P>dataframe is having firstname,lastname,middlename,id,salary</P><P></P><P>I need to convert dataframe in xml file but in nested format.</P><P></P><P>output as nested xml</P><P></P><P>&lt;Name&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&lt;firatname&gt;</P><P> &lt;middlename&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&lt;lastname&gt;&nbsp;&nbsp;&nbsp;&nbsp;</P><P>&lt;/Name&gt;</P><P>&lt;id&gt;&lt;/id&gt;</P><P>&lt;salary&gt;&lt;/salary&gt;</P><P></P><P></P><P>Anyone has ides hot to achieve this.</P> Tue, 27 Sep 2022 06:47:08 GMT PriyaTech 2022-09-27T06:47:08Z Converting Dataframe into Nested xml https://community.databricks.com/t5/data-engineering/converting-dataframe-into-nested-xml/m-p/30708#M22292 <P>e.g.</P><P></P><P>dataframe is having firstname,lastname,middlename,id,salary</P><P></P><P>I need to convert dataframe in xml file but in nested format.</P><P></P><P>output as nested xml</P><P></P><P>&lt;Name&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&lt;firatname&gt;</P><P> &lt;middlename&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&lt;lastname&gt;&nbsp;&nbsp;&nbsp;&nbsp;</P><P>&lt;/Name&gt;</P><P>&lt;id&gt;&lt;/id&gt;</P><P>&lt;salary&gt;&lt;/salary&gt;</P><P></P><P></P><P>Anyone has ides hot to achieve this.</P> Tue, 27 Sep 2022 06:47:08 GMT https://community.databricks.com/t5/data-engineering/converting-dataframe-into-nested-xml/m-p/30708#M22292 PriyaTech 2022-09-27T06:47:08Z Re: Converting Dataframe into Nested xml https://community.databricks.com/t5/data-engineering/converting-dataframe-into-nested-xml/m-p/30709#M22293 <P> databricks has a xml connector:</P><P><A href="https://docs.databricks.com/data/data-sources/xml.html" alt="https://docs.databricks.com/data/data-sources/xml.html" target="_blank">https://docs.databricks.com/data/data-sources/xml.html</A></P><P>Basically you just define a df with the correct structure and write it to xml.</P><P>To create a nested df, <A href="https://stackoverflow.com/questions/57079343/spark-create-a-nested-schema" alt="https://stackoverflow.com/questions/57079343/spark-create-a-nested-schema" target="_blank">here you can find some info</A>.</P> Tue, 27 Sep 2022 09:42:38 GMT https://community.databricks.com/t5/data-engineering/converting-dataframe-into-nested-xml/m-p/30709#M22293 -werners- 2022-09-27T09:42:38Z