xml read

basu.ds · Post by **basu.ds** » Tue Dec 08, 2009 8:02 am

Hi

I am unable to split into columns from xml document.this is the format i am getting
<identifier itemkey="0000056G8120">CARDPOP- STACKER DRIVER CARD</identifier>
<identifier itemkey="0000056G8127">DRIVE ASM</identifier>
<identifier itemkey="0000056G8151">CARDPOP STKRDRVRALL14</identifier>

i need output as
000056G8120 CARDPOP- STACKER DRIVER CARD
0000056G8127 DRIVE ASM
0000056G8151 CARDPOP STKRDRVRALL14

but i am getting like this
0000056G8120
CARDPOP- STACKER DRIVER CARD
0000056G8127
DRIVE ASM
0000056G8151
CARDPOP STKRDRVRALL14

please help me any one ...

Thanks in advance

chulett · Post by **chulett** » Tue Dec 08, 2009 8:55 am

Please post this in the correct forum.

eostic · Post by **eostic** » Wed Dec 09, 2009 7:51 am

not sure how one "moves" the thread, but in the meantime, if you are succesfully parsing out the attribute and element, it is unlikely that it's the XMLInput Stage that is causing your data to be on two lines. Generally, an attribute and element value like this will all be on the same row. The output link on your xmlInput Stage ought to have the following xpath in the Description property at the far right (I will assume at the moment that there is more to this xml document):

.../identifier/@itemkey
.../identifier/text()

...also, without seeing the whole document it is a bit difficult to predict, but it's likely that the second column should be the key.

Ernie

chulett · Post by **chulett** » Wed Dec 09, 2009 8:19 am

One doesn't, only a moderator (or I guess a 'content editor' <waves to Andy>) can actually move posts which is why I asked them to re-post it. And for whatever it is worth, I've stopped replying to posts that are in egregiously incorrect forums... I mean, how hard is it to get that right? Or at least right enough.

Now that there's an answer here, let's see if we can get this moved.

Moderator, please move to the Enterprise forum.