03-20-2013 04:55 AM
I have a set of files I need to process with the same XMLMAP. My latest approach is to attempt to capture the Filename as a column. Following code runs but contents of File variable is missing.
<TABLE description="Application" name="Application">
<COLUMN class="FILENAME" retain="YES" name="File">
I wonder how I could have this incorrect.
03-28-2013 05:12 PM
I have an example and it is attached: the password is qwerty99. It looks like sensitive data but it isn't and consists of industry accepted examples.
04-03-2013 05:11 PM
I have discovered that this is a known problem with the class="FILENAME" usage in the XML LIBNAME engine. Unfortunately, there currently does not appear to be a work-around for the problem with this functionality.
04-03-2013 05:55 PM
Thanks Bill - serves me right for reading the documentation:smileyconfused:
My more general problem is that I want to concatenate a bundle of XML documents/ files and parse the as a single file. This seems to work except that there are different Ordinal values maintained for each file. Ultimately, this means I end up with entries in the resulting tables that have duplicate values for the ordinal. Is there a code pattern that would allow me to accomplish the concatenation with the ordinals maintained across them all? [My initial hope was use the filename to distinguish the entries].
Any thoughts / approach would be much appreciated.
04-28-2015 10:54 AM
Has this issue been resolved (more importantly is there a workaround)? I just spent hours trying to get class="FILENAME" and class="FILEPATH" to work only to get blanks instead. Like Dave I am reading thousands of XML files as one concatenated file and keeping track of where values come from is imperative and duplicate ordinals don't cut it in my application. My workaround is to loop through all the files individually but ...