How do we pass the row tags dynamically while reading a XML file into a dataframe?

[Stita]

I have a set of xml files where the row tags change dynamically. How can we achieve this scenario in databricks.

df1=spark.read.format('xml').option('rootTag','XRoot').option('rowTag','PL1PLLL').load("dbfs:/FileStore/tables/ins/")

We need to pass a value dynamically in place of PL1PLLL option('rowTag','PL1PLLL')

[Kaniz]

Hi @Stitapragna B​, In this article, It will explain how to read an XML file with several options using the Scala example. Please let me know if that helps, or else we'll find an alternative answer for you.

[Kaniz]

Hi @Stitapragna B​ ​, We haven’t heard from you since the last response from me, and I was checking back to see if you have a resolution yet.

If you have any solution, please share it with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.

[Hubert-Dudek · Accepted solution]

If it is dynamically for the whole file, you can just use variable

tag = 'PL1PLLL'
df1=spark.read.format('xml').option('rootTag','XRoot').option('rowTag' ,tag).load("dbfs:/FileStore/tables/ins/file.xml")