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

Read XML and write to Talend XML component

Hi,
I am trying to convert an xml file to talend component xml file so that from the new talend xml component file , I can able to create java source from Talend.

But when I try to read an xml file using tFileInputXML, am not able to give the xml schema to tFileInputXML component to read the existing xml file and trying to put in tAdvancedFileOutputXML component. In this component I can able to select the xsd but am getting the error message saying "Parameter (XML Loop) must have atleast one value".

Kindly help me to resolve this issue.

Thanks & Regards,
Inigo Skylab
Labels (4)
3 Replies
Anonymous
Not applicable
Author

Hi,
Now I can able to read XML file using tFileInputXML but in output am not getting the loop data.
i.e.; The original xml file is
<Vector__Changed>
<person>
<firstname>Joe</firstname>
<lastname>Walnes</lastname>
<phone>
<code>123</code>
<number>1234-456</number>
</phone>
<fax>
<code>123</code>
<number>9999-999</number>
</fax>
<phoneList>
<phonenumber>
<code>456</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>879</code>
<number>9999-999</number>
</phonenumber>
</phoneList>
</person>
<person>
<firstname>Inigo</firstname>
<lastname>Skylab</lastname>
<phone>
<code>123</code>
<number>1234-4567</number>
</phone>
<fax>
<code>123</code>
<number>9999-999</number>
</fax>
<phoneList>
<phonenumber>
<code>456</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>879</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>222</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>555</code>
<number>9999-999</number>
</phonenumber>
</phoneList>
</person>
</Vector__Changed>
and the generated xml file from Talend tAdvancedFileOutputXML component is
<?xml version="1.0" encoding="ISO-8859-15"?>
<Vector__Changed>
<person>
<firstname>Joe</firstname>
<lastname>Walnes</lastname>
<phone>
<pcode>123</pcode>
<pnumber>1234-456</pnumber>
</phone>
<fax>
<fnumber>9999-999</fnumber>
<fcode>123</fcode>
</fax>
<phoneList>
<phonenumber>
<pncode>456</pncode>
<pnnumber>9999-999</pnnumber>
</phonenumber>
</phoneList>
</person>
</Vector__Changed>
Under Phone number tage the loop has not taken place and under person tag, Inigo Skylab data has not generated from original file.

Please suggest anything else to be added in configuration part.
Thanks & Regards,
Inigo Skylab
_AnonymousUser
Specialist III
Specialist III

Hi
I'm trying to do a very simple XML file transformation and I'm getting the same error (and I've had the same results - just one record in the outfile)
Did you get an answer from anyone in the end? Or did you manage to figure it out?
I'd be keen to hear?
Thanks
Dave
Anonymous
Not applicable
Author

You can try using component tFileInputMSXML
BR,
Roman