Hi friends,
I am new to XML and have a requirement where I need to Publish 1000 recodrs and 70 column data from a single flatfile/database into an XML file.I don't have any other information as how the XML document should look like apart from flat file.so i used XML o/p stage. But in o/p ,for each column ,i do not want to specify the path manually... is there any to produce these XPaths in GUI given I just have all the records in .txt file .
for eg : in XMP o/p stage and in o/p page
col.A-varchar(50)-/customer/A/text()
col.B-char(10)-/customer/B/text()
In the above scenario, i don't want to manually type these path info for all 70 column?
Thank you.
XML
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Mannu,
What I understood from your query is, target XML structure is not yet finalize (or could be Dynamic) but you want to give XML structure at run time...
For this, use XML Transform stage after XML Output stage and use XSL to write the structure of XML. You can modify this XSL anytime without touching the code and the XML output will be as per defined in XSL...
What I understood from your query is, target XML structure is not yet finalize (or could be Dynamic) but you want to give XML structure at run time...
For this, use XML Transform stage after XML Output stage and use XSL to write the structure of XML. You can modify this XSL anytime without touching the code and the XML output will be as per defined in XSL...
Regards,
Sunny Sharma.
Sunny Sharma.