DSXchange

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.

Hi! Poorna

in your Xml path definition(in xml input stage) make sure that, you also enter text()
I.e:......../../../Organization/text()

Kalpna

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

Hi! Poorna
I was refering to
Xml input-->Output Tab-->Columns-->Description
There you have your xml path defined for each column.

Kalpna

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.