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: 
talendtester
Creator III
Creator III

tExtractXMLField - Content is not allowed in prolog.

My job:
tFileInputXML > tExtractXMLField > tFileOutputDelimited

Error I am getting:
Error on line 1 of document  : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.
Top of my XML file:
<?xml version='1.0' encoding='utf-8' ?>
<workbook source-platform='win' version='9.0' xmlns:user='http://www.tableausoftware.com/xml/user'>
  <!-- build 9000.15.0318.1720                                -->
  <preferences>
    <preference name='ui.encoding.shelf.height' value='24' />
    <preference name='ui.shelf.height' value='26' />
  </preferences>
  <datasources>
Labels (3)
2 Replies
Anonymous
Not applicable

Good day
I don't understand because you have 2 components to extract xml content.  Only put a tFileInputXml is sufficient to resolve the 90% of the problems.    
Do you need to extract nested xml fields?
Please try to use only a tFileInputXml or show me the output fields to extract.
Best regards,
Alfonso Borre
Skype : alfonso.borre
aborresarmiento@yahoo.es
isodelta
Contributor
Contributor

You need to check 2 parameters in the `tExtractXMLField` component :

  • `XML Filed`
  • `Loop XPATH Query`. <br> I think this needs to look like `/workbook/something`

 

Could you supply us more about the XML data you need to extract and `tExtractXMLField` parameters.

Sincerely,

 

Rabah LEKHEBASSENE