cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Need help on XML file convert to CSV

shavadivu
New Contributor II

i have book.xml file with book.XSD file and trying convert into csv file but book.xml missing some element in the xml file. In CSV file required and present and missing element information should visible with blank value with header.
I have tried xml parser and mapper and xml formatter but not able produce missing element in xml for bk003[],bk004[genre>,]

testxml and XSD.txt (1.8 KB)

6 REPLIES 6

@shavadivu, you can find the XSD file used in the XML Formatter of my pipelines.

shavadivu
New Contributor II

Thanks and I have tried with attached example xml with XSD file but CSV formatter failed with data need to flatten output of json parser. but CSV requirement is same.
XML file reading from Folder and XML file some elements May or may not come but If elements come then CSV file should have elements header and value else CSV file should have element header with blank value
BOOKORDER_XSD and XML.txt (4.1 KB)