Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
poorna_76
Charter Member
Posts: 190 Joined: Thu Jul 08, 2004 10:42 am
Post
by poorna_76 » Thu Feb 16, 2006 10:16 am
Hi All,
I haven't dealt with XML files before.
I have a simple XML file and trying to convert to falt file (.TXT file).
I used FolderStage --->XMLInput ---->SequentialFile .
I am getting output like this:
<OrganizationID>10412</OrganizationID><ClubID>12320</ClubID>
<OrganizationID>10413</OrganizationID><ClubID>12320</ClubID>
But I would like generate file like this:
OrganizationID,ClubID
10412,12320
10413,12320
Any thoughts on how to do this?
Thanks in Advance.
kalpna
Premium Member
Posts: 78 Joined: Thu Feb 02, 2006 3:56 am
Post
by kalpna » Thu Feb 16, 2006 10:30 am
Hi! Poorna
in your Xml path definition(in xml input stage) make sure that, you also enter text()
I.e:......../../../Organization/text()
Kalpna
poorna_76
Charter Member
Posts: 190 Joined: Thu Jul 08, 2004 10:42 am
Post
by poorna_76 » Thu Feb 16, 2006 10:40 am
kalpna wrote: Hi! Poorna
in your Xml path definition(in xml input stage) make sure that, you also enter text()
I.e:......../../../Organization/text()
Kalpna
Hi Kalpna,
In the XML InputStage-XML source,
i don't see that option.
i only see XMLSource column
Column content :XMLdocument or URL/FilePath
Thanks
kalpna
Premium Member
Posts: 78 Joined: Thu Feb 02, 2006 3:56 am
Post
by kalpna » Thu Feb 16, 2006 10:47 am
Hi! Poorna
I was refering to
Xml input-->Output Tab-->Columns-->Description
There you have your xml path defined for each column.
Kalpna
poorna_76
Charter Member
Posts: 190 Joined: Thu Jul 08, 2004 10:42 am
Post
by poorna_76 » Thu Feb 16, 2006 11:19 am
kalpna wrote: Hi! Poorna
I was refering to
Xml input-->Output Tab-->Columns-->Description
There you have your xml path defined for each column.
Kalpna
Thanks Kalpna.
That worked.