Parsing a list of xml files

[hiba1]

i have 38 xml file.

i want to parse this files and then insert data into sql server .

any help please ! 

[Anonymous]

Hi,

    If the XML structures are same, you can use tFILEList to read one file at a time. Then parse the XML data using tFILEInputXML and send the output to tMSSQLOutput.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[hiba1]

Hi ,

i try to produce this job : 

So i got this error:

[Anonymous · Accepted solution]

Hi Hiba,

If you have a same structure XML file in the directory then you can use tFileList and tFileInputXML to load data into the target.

In the tFileInputXML under file name give name as [((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))]

And the output will be 

If you want to load into any database by giving dynamic schema you load.

[hiba1]

Hi,

Thanks a lot for the reply.

your solution worked