Parsing multiple XML files
Posted: Mon Mar 31, 2008 1:37 pm
Hi,
I have to parse multiple XML files named as replyfile*.xml (using wildcard as the files have a datetime stamp in the name).
I tried 2 designs
1.
External Source Stage -----> XML Input stage ------> SEQL file
and gave following command in external source stage: ls /directory/replyfile*.xml
Although it did send the required filenames to XML Input stage but the XML stage could not parse multiple files and gave 0 records as output.(XML Source set as 'filepath')
2.
SEQL File stage ------> XML Input stage -------> SEQL File stage
The first SEQL file stage is to read XML file pattern (i.e. all the files together in one go).....but again the XML Input stage could not parse it.
Is there any property which I am missing here, or something I am not doing correctly? If its one file the parsing is successful using Design 1, so no problem with the xpaths.
OR is there a better approach to process multiple files (note: I am not allowed use loops in job sequencer)
Thanks
roy
I have to parse multiple XML files named as replyfile*.xml (using wildcard as the files have a datetime stamp in the name).
I tried 2 designs
1.
External Source Stage -----> XML Input stage ------> SEQL file
and gave following command in external source stage: ls /directory/replyfile*.xml
Although it did send the required filenames to XML Input stage but the XML stage could not parse multiple files and gave 0 records as output.(XML Source set as 'filepath')
2.
SEQL File stage ------> XML Input stage -------> SEQL File stage
The first SEQL file stage is to read XML file pattern (i.e. all the files together in one go).....but again the XML Input stage could not parse it.
Is there any property which I am missing here, or something I am not doing correctly? If its one file the parsing is successful using Design 1, so no problem with the xpaths.
OR is there a better approach to process multiple files (note: I am not allowed use loops in job sequencer)
Thanks
roy