tFileInputXML generates no output

[PD2]

I know I must be doing something wrong but not sure what.
I have configured the tFileInputXML to read and XML file.
I have configured my Xpath loop expression as well as the fields to extract.
When I click on "Refresh Preview" everything is there, just like I want it.
I then connect the tFileInputXML to a tFileOutputDelimited via Main.
I configure tFileOutputDelimited and run the job.
Nothing gets written to the the "csv" file configured in tFileOutputDelimited, just the header row.
How is it the the "preview" works but the job when run finds no rows?

I receive no errors so it must be me. Just not sure what to do next.
Thanks
Peter

[Anonymous]

I guess the schema definition from the tFileOutputDelimited has destroyed your schema and mapping from the tFileInputXML.
Put a tMap between both and try it again.

[ff06 · Accepted solution]

Just had the same issue and I found that it was related to the xpath loop limit settings.
First, I read some misleading information saying that this limit should be zero but in fact this limit should be -1.
See the links here:
https://help.talend.com/search/all?query=tFileInputXML&content-lang=en
and
https://community.talend.com/t5/Design-and-Development/resolved-Transforming-XML-to-CSV/td-p/75977

[Anonymous]

I had a similar issue when I was following some document saying 0 to process unlimited rows. Spent 1.5 hours trying different options to make it work but since there was no error throws it was very difficult to debug.

Finally your repsonse in this thread saved me the trouble. it worked absolutely fine by just changing limit to -1.

thanks once again for sharing the information and the link for future use.

[ff06]

You're welcome !

Always happy to help.