Is possible to use Read-XML() just to read part of an XML file instead of the whole file? Say, from an XML file of transactions from all accounts, is it possible just to read in those from a certain account?
When opening the XML in a browser you can see that the output xml is correctly filtered. However when continuing the progress code, all records are returned.
Alternatively:
xslt process the xml first using your favorite third party library.
use the sax-reader to import the xml and let that skip all irrelevant parts
but the easiest is to simply import the lot with read-xml and then delete the temp-table records that do not meet your criteria.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.