We have used XML input stage to read Xml file. Bofore XML input stage we have used external source stage to feed the XML input stage.
We have loaded the the XML input stage its meta data, and made a column as 'key' column since I got a warning that a key column should be specified for a repetition element.
Problem is that I am getting single row as output from the XML stage even though the xml file has multiple rows. All the required output feilds will become as single row in the output.
Please suggest if there is any solution for this issue.
Single row output from XML input stage!!
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Mon Dec 27, 2004 3:38 am
Need more information. Each xml file will be read by the stage as 'one record' so that in and of itself is not an issue. What is your expected output here? Are you generating a sequential file? Can you be more specific about your output, please? Examples are always good.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 60
- Joined: Mon Dec 27, 2004 3:38 am
Output of XML input stage is feeded to lookup stage and from this stage to table.
input consists of group of repeting section like this.
And we want each repeating groups to be a row in the output, like
1 2
3 4
input consists of group of repeting section like this.
Code: Select all
<a>
<b>1</b>
<c>2</c>
</a>
<a>
<b>3</b>
<c>4</c>
</a>
1 2
3 4
-
- Participant
- Posts: 60
- Joined: Mon Dec 27, 2004 3:38 am
Code: Select all
Tag b --> /a/b
Tag c --> /a/c
...you need to finish it....
/a/b/text()
/a/c/text()
...and make one of them a "key".
Ernie
/a/b/text()
/a/c/text()
...and make one of them a "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>