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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Artemis_Mercury
Contributor
Contributor
‎2023-08-29 12:19 PM

Combining multiple XML into one using the same schema

Hello,

I'm currently facing a situation where I have several XML files that conform to a shared schema. However, each of these files holds data related to a distinct parent element within the schema. My goal is to merge these files into a unified tFileOutputXML, and I'm utilizing a tXMLMap for this task. Unfortunately, the result I'm getting seems to be duplicating the entire schema for each individual row of data that I input.

Could you kindly guide me on the steps to rectify this issue? I aim to generate a valid XML output that adheres accurately to the XSD Schema I imported. For additional clarity, I've attached some screenshots for your reference.

tXMLMap

0695b00000nSAc7AAG.png

0695b00000nSAcRAAW.png

tFileInputXML_1

0695b00000nSAfBAAW.png

tFileInputXML_2

0695b00000nSAfpAAG.png

tFileOutputXML

0695b00000nSAgOAAW.png

tFileOutputXML Schema

0695b00000nSAh2AAG.png

XML output

0695b00000nSAhbAAG.png

Labels (3)
Labels
516 Views
0 Likes
0 Replies