As per my requirement, I need to convert XML files into CSV file using perl scripting. Currently I recieve multiple xml files with different schema structure.
How can i read the XML files with different structure for example I can have two files as specified below:
XML File 1:
<root>
<Report>
<EMP>
<ID>1</ID>
<Name>XXX</Name>
<Company>YYY</Company>
<Join_Date>2010-10-16</Join_Date>
</EMP>
<DEP>
<DEP>
<DEP_ID>2</DEP_ID>
<DEP_Name>XX</DEP_Name>
<Jobtitle></Jobtitle>
<Jobdescr></Jobdesc>
</DEP>
<DEP>
<DEP_ID>3</DEP_ID>
<DEP_Name>YY</DEP_Name>
<Jobtitle></Jobtitle>
<Jobdescr></Jobdesc>
</DEP>
XML File 2:
<root>
<Order>
<OrderId>2</OrderId>
<TxnNumber>1</TxnNumber>
<OrderDesc>General Information</OrderDesc>
<Location>ABC</Location>
</Order>
Hence how to read the xml files dynamically and convert it to a csv files without any xsd defined?