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