i am new to XSLT and have gone through some of the earlier thread on SO Thread i Followed
my requirements are similar and i need to convert XML to CSV, for e.g i have following XML
<?xml version="1.0" encoding="UTF-8"?>
<impex>
<record>
<Employee/>
<UID>aa</UID>
<Name>HR Manager</Name>
<Groups/>
<Password>123456</Password>
</record>
<record>
<Employee/>
<UID>bb</UID>
<Name>HR Executive</Name>
<Groups/>
<Password>123456</Password>
</record>
</impex>
and i need to convert this XML to following csv output
INSERT_UPDATE Employee;UID[unique=true];name;groups(uid);password
;"aa";"HR Manager";;"123456"
;"bb";"HR Executive";;"123456"
where i have to manage csv headers dynamically (based on xml elements)
additonaly i have also to take care if some of the values are missing i can provide them e.g is missing or its empty in such case i need to provide some default value to the generated csv as this csv will be the final output which will be imported to the system
any starting help by which i can move ahead will be much appreciated