Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Read many similar xml files

Hi!
I have 100 xml files with the same structure: xml_1, xml_2, xml_3,.... xml_100. They are all stored in a folder. How can I use JasperETL to read data in all the xml files into database? Currently I add one xml file into metadata and use tFileInputXML and tMysqlOutput to read data in that xml file into database. However, it can only read one file. If I want to read 100 files, I will have to add these 100 files to metadata. Is there any better way to do it?
Thanks
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hello
Using tFileList to iterate each file, for example:
tFileList--iterate--tFileInputXML--main---tMysqlOutput
Best regards
Shong