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