XML Issue

[poorna_76]

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]

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]

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]

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]

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.