Load multiple XML Files into a mySQL DataBase

One Star

Load multiple XML Files into a mySQL DataBase

Hi,
I have a foder where I have 3 xml Files CDR01--CDR03 which have the same format. I want to select these three files, process them (extract only some information from) and then put the extracted data into a DataBase.
I used the
Tfilefilter : where I gave the link of the folder where I have my xml files,
tFilelinputXml: and here is where I have the problem : it when I need to give the "file name/Stream" and here I have just one option is to give the link for one xml file.
So when I run the Job I have in my Database the selected file 3 times.
So my question is how to tell to the tFileInputXML to have as input a different files.
Thank you I hope I am clear.

One Star

Re: Load multiple XML Files into a mySQL DataBase

Hi
Type this expression in the "file name/Steam" text field on tFileList.
((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
Regards,
Pedro
One Star

Re: Load multiple XML Files into a mySQL DataBase

Thanks a Lot It worked Smiley Happy