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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem converting XML with multiple loop

Hello,
I have problems with converting one XML to another with difference structure.
If you know LCI data format, im converting difference data format (from Ecospold to ILCD) which is the two of them using XML as data format.
here what is look like in simple way:
from this:
<processDataSet xmlns=" http://lca.jrc.it/ILCD/Process" xmlns:common=" http://lca.jrc.it/ILCD/Common" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance" metaDataOnly="false" locations="../ILCDLocations.xml" version="1.1" xsi:schemaLocation=" http://lca.jrc.it/ILCD/Process ../../schemas/ILCD_ProcessDataSet.xsd">
<processInformation>
<dataSetInformation> <common:UUID>9ca9d601-15b7-45c3-84ad-e46f9a165809</common:UUID> <nam

To see the whole post, download it here
Labels (4)
14 Replies
Anonymous
Not applicable
Author

Hi Rocknrolla
I try to reproduce the job you mentioned above.
But I find that the format of these two xml files are not correct.
Could you simplify the structure of them?
Did you check "Create empty element if needed" in tFileOutputMSXml->Advanced Settings?
Moreover, since TOS 5.1.0, tXMLMap supports multiple loop feature.
Regards,
Pedro
Anonymous
Not applicable
Author

Hi Rocknrolla
I try to reproduce the job you mentioned above.
But I find that the format of these two xml files are not correct.
Could you simplify the structure of them?
Did you check "Create empty element if needed" in tFileOutputMSXml->Advanced Settings?
Moreover, since TOS 5.1.0, tXMLMap supports multiple loop feature.
Regards,
Pedro

hello, thx for the quick respond
Its not correct because it is not the actual file, edit: i cant upload it because it is too long and the forum not allowing me to post it all
i check the tFileOutputMSXml component file, edit: and i already check create empty element if needed but the empty element from the imported xml structure wont showed up
and how to use tXMLMap to use multiple loop? and can it connected with file output XML with the same structure, i mean the XML tree in the file output is difference right?
i use TOS 5.0.2 i think i should upgrade it
Anonymous
Not applicable
Author

Hi
Could you send me an email and attach these two xml?
Because without reproducing this issue, I can not point out how to fix it.
Regards,
Pedro
Anonymous
Not applicable
Author

Hi
Could you send me an email and attach these two xml?
Because without reproducing this issue, I can not point out how to fix it.
Regards,
Pedro

i will email it
also can you explain how to use tXMLmap+tAdvanceFileOutputXML combined?

thanks
Anonymous
Not applicable
Author

Hi
When using tFileOutputMSXML, if an attribute gets null values, this attribute will disappear in output XML file.
It seems to be a bug. Please report it on BugTracker.
When using tXMLMap, it works fine.
So now the workaround is to use tXMLMap.
Just link tXMLMap with tFileOutputDelimited which has only one 'Document' column.
The file name of tFileOutputDelimited should be *.xml.
Regards,
Pedro
Anonymous
Not applicable
Author

Hi
When using tFileOutputMSXML, if an attribute gets null values, this attribute will disappear in output XML file.
It seems to be a bug. Please report it on BugTracker.
When using tXMLMap, it works fine.
So now the workaround is to use tXMLMap.
Just link tXMLMap with tFileOutputDelimited which has only one 'Document' column.
The file name of tFileOutputDelimited should be *.xml.
Regards,
Pedro

i had use your methods, at first it is okay. Little mess at the structure but is is not a problem, i can produce null attribute. But, when i apply some loop, the problem start
the looping is applied on whole XML, so if there is next loop applied the whole XML is written and so on.
Anonymous
Not applicable
Author

Hi
The "all in one" feature can be found in tXmlMap Settings which supports generating multi rows into one xml row as the following image.
Regards,
Pedro
Anonymous
Not applicable
Author

Hi
The "all in one" feature can be found in tXmlMap Settings which supports generating multi rows into one xml row as the following image.
Regards,
Pedro

its working now 0683p000009MACn.png
thanks a lot
Anonymous
Not applicable
Author

Hi
The "all in one" feature can be found in tXmlMap Settings which supports generating multi rows into one xml row as the following image.
Regards,
Pedro

Hello,
it turns out my problem is not solve yet
The xml is looping, the file is produce all is good, but the my main problems which is multiple loop still cant be done. i tried with multiple loop using TOS 5.1 as you suggested but when i applied it, it produce nothing.
for your information, i separate the input from same XML files and combined it later in the XMLmap. are my method is incorrect?
as you can see on the picture below, i separate the file and it produce 73 rows in elecNSW_3 and 4 rows in elecNSW_4. but only 1 row in the output.