Read many similar xml files

One Star

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
Community Manager

Re: Read many similar xml files

Hello
Using tFileList to iterate each file, for example:
tFileList--iterate--tFileInputXML--main---tMysqlOutput
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business