topic Re: Import multiple XML files and extract to Excel file. in Talend Studio

Import multiple XML files and extract to Excel file.

EFORCAN — Thu, 27 Oct 2022 17:55:39 GMT

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

Re: Import multiple XML files and extract to Excel file.

Anonymous — Fri, 28 Oct 2022 01:41:13 GMT

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

Re: Import multiple XML files and extract to Excel file.

EFORCAN — Fri, 28 Oct 2022 13:45:22 GMT

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: