Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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