Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
MAnywar
Contributor III
Contributor III

Help with Processing and mapping multiple xml files

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.

​

0693p00000AYrEpAAL.png

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

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

View solution in original post

3 Replies
MAnywar
Contributor III
Contributor III
Author

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

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

​

Thank you.

​

​

Anonymous
Not applicable

Hi

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

MAnywar
Contributor III
Contributor III
Author

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