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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Input XML file with hierarchy

Hello, new here. I did try searching for this issue, but didn't see anything relevant for an input file.
I am trying to take an XML file that contains a hierarchy of data and import it into Salesforce.
An example of the file is attached as taxonomy_sample.xml.txt.txt.
And the XSD is attached as taxonomy.xsd.zip.zip.

Notice how the "taxonomy" element contains a sequence element "record", and if you look at this complex type, it has a sequence element of "record". What you then have is a hierarchy of "record".
I created my data model in Salesforce where I have a "Parent" lookup relationship custom field that I will use to create this hierarchy.
When I try to add this file as an XML input file, Talend Open Studio is locking up.

Also note that the real file is somewhat large at 22mb and has about 10k entries total.

Any suggestions how can I get this input file read into Talend and import it into Salesforce?
taxonomy_sample.xml.txt.txttaxonomy.xsd.zip.zip

Labels (2)
1 Reply
Anonymous
Not applicable
Author

It doesn't look like the files uploaded, trying again in a single archive.
xml_hierarchy.zip.zip