Import multiple XML files and extract to Excel file.

[EFORCAN]

Hello.

I'm new to the Talend community and would like to know if anyone can help me with a Job I'm trying to do.

I have a directory that will be updated with XML files (same structure as XML files), so I need to read all these files, and extract them to an Excel file.

I can read the files, but it only saves the same XML.

Follow Job.

Eder

[Anonymous · Accepted solution]

Hello,

To achieve your goal, please reset the File name to globalMap.get("tFileList_1_CURRENT_FILEPATH") for tFileInputXML_1 component as the below

 

and check the 2 buttons "Append existing file" & "Append existing sheet" for tFileOutputExcel_1 component as the below

 

[EFORCAN]

Hello achen. Thank you very much for the help, it worked very well with your information. Thank you very much. Em qui., 27 de out. de 2022 às 22:41, Talend escreveu: