Posted: Mon Jan 21, 2013 4:07 pm
I haven't seen this in awhile. Noticed it most often when there are very few columns in the sub-columns of the repeating node.
Try this: Add a dummy column that is 100% unique (use something like @INROWNUM upstream)...put this dummy column just above ProdCode in the link and give it xpath (the Description property) that looks just like ProdCode but with /dummy/text() at the end instead of ProdCode/text().
See if that produces the xml that you need....of course, it will have an extra element called "dummy".......put an output link on your xmlOutput Stage with a single large varchar column and a single '/' in the Description property. Send that to a Transformer or other means for removing the dummy element.
Ernie
Try this: Add a dummy column that is 100% unique (use something like @INROWNUM upstream)...put this dummy column just above ProdCode in the link and give it xpath (the Description property) that looks just like ProdCode but with /dummy/text() at the end instead of ProdCode/text().
See if that produces the xml that you need....of course, it will have an extra element called "dummy".......put an output link on your xmlOutput Stage with a single large varchar column and a single '/' in the Description property. Send that to a Transformer or other means for removing the dummy element.
Ernie