How to Convert XML file into CSV file using NIFI

[#1]

i have XML files about 1-2 GB i want it to convert into CSV format using apache nifi.

so that i can process CSV for joining the two csv.

[#2]

Hi @Nitin Damle

I'm assuming you got the flow working with the sample data and template I provided.

Can you provide an example of the desired csv output you are hoping to achieve from the cm_samples.xml file you provided? That would help me understand your end goal for the flow.

Thanks!

[#3]

xmlsampleop.png

@Andrew Lim you can refercm_sample.txt

this image and file

[#4]

Thanks for the information Nitin.

It seems like it would make sense to "clean up" your incoming XML using the TransformXML processor (https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.6.0/org.apache...) prior to ConvertRecord since there is data there like the header info that you don't care about for the CSV file. Additionally, could change the tag from `p` to its `name` attribute.

I haven't used the TransformXML processor before (or worked with XSLT files before). Take a look yourself and see if you think it could be a solution for you. I will try it out myself if I get the opportunity.

[#5]

Hi Andrew,

I am not able to convert xml to csv as suggested by you to do the inverse of this. Could you please provide the nifi xml file so that I can upload the template and check.

[#6]

convert-xml-to-csv.xml

[#7]

Hi Andrew , this works for single xml but I have nested xml. How to convert nested xml to multiple csvs ?

[#8]

@Andrew Lim Is there anything possible for nested xml to multiple csvs ?Attached is the nested xml file ad.xml

[#9]

@Andrew Lim After importing it giving me this error

[#10]

FYI

https://community.hortonworks.com/questions/226390/nifi-18-error-updateattribute-is-not-known-to-thi...

[#11]

You can use this NIFI Groovy processor that converts XML to CSV or AVRO

https://github.com/maxbback/nifi-xml