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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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