topic Re: Help with Processing and mapping multiple xml files in Talend Studio

Help with Processing and mapping multiple xml files

MAnywar — Sat, 16 Nov 2024 01:06:18 GMT

Hello, I am stuck at the moment with my current project. I have a about 300+ files that I need to process till output. But at the moment I can only process just one files at a tile while manually changing the input file and also the output file name.

I would like this to be done automatically how ever, At the start tFiles can access/ fill files from their root directory, however the problem starts when the tExtractxml component extracts fields from all the files at once, before sending to the tXMLMAP.

I would like tEXtractXML to extract once file at time, until the output.

I will surely be grateful for any help and guidance.

Thank you all.

Re: Help with Processing and mapping multiple xml files

MAnywar — Tue, 17 Nov 2020 12:53:32 GMT

So as I mentioned at the moment, all I can do that would involved all the files is this:

No Issue now is proceeding with the exported values from the tExtract. Which need to be mapped then have to be output individually.

Thank you.

Re: Help with Processing and mapping multiple xml files

Anonymous — Wed, 18 Nov 2020 01:47:56 GMT

All XML files have the same XML tree structure? If want to generate a separated XML file for each input XML file, you need to set a dynamic file name on tFileOutputXML, eg:

"D:/directory_path/"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+".xml"

Regards

Shong

Re: Help with Processing and mapping multiple xml files

MAnywar — Wed, 18 Nov 2020 10:21:22 GMT

Thanks so much @Shicong Hong This worked perfectly well just as I desired.