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
xml read
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
.../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
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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. ![Wink :wink:](./images/smilies/icon_wink.gif)
Now that there's an answer here, let's see if we can get this moved.
Moderator, please move to the Enterprise forum.
![Wink :wink:](./images/smilies/icon_wink.gif)
Now that there's an answer here, let's see if we can get this moved.
Moderator, please move to the Enterprise forum.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers