XML stage in DS v8.5

senthilmp · Post by **senthilmp** » Tue Mar 27, 2012 1:26 am

Am using XML 8.5 stage to read an XML file, when there are values in the XML file the stage works fine and gives the desired result. But when we are not giving any tag for that particular field in the input XML file the output is derived as 1.00 rather than a null. Have anyone encountered this issue? Please share your suggestion.

eostic · Post by **eostic** » Tue Mar 27, 2012 2:14 pm

While anything is possible, I've never seen it put something "else" in there. Check your logic and be sure you are debugging this problem directly on the output link from the Stage, and not anywhere downstream....

...be careful about what it means to have "no value".....if you have left the defaults "as is" [there are a variety of settings that control whether you should get null or blanks], and this element is NOT your repetition element, then it will be null.....

...but if this element IS your repetition element, then something much different could be occurring --- if you have "repetition element required", then you may actually be "dropping" that node entirely....and thus skewing behavior downstream.

It depends on a lot of things, like the depths of your structure, but consider all of these possibilities in your analysis.

Ernie