Need help while reading xml file

moulipx · Post by **moulipx** » Sat Oct 06, 2012 11:59 pm

Hi all,

Could you please help me in reading below XML file .I need to produce an sequential file from Xml input file .

<Employee Place="USA" Status="Active" Date="2012-09-30">
<Name="AAA" No="1" Grade="B" />
<Name="BBB" No="2" Grade="D" />
<Name="CCC" No="3" Grade="F" />
</Employee>

I need to Create output file as below format

Name,No,Grade
AAA,1,B
BBB,2,D
CCC,3,F

chulett · Post by **chulett** » Sun Oct 07, 2012 5:19 am

What kind of help do you need? What have you tried and what issues have you faced? Have you ever worked with XML before?

moulipx · Post by **moulipx** » Tue Oct 09, 2012 12:41 am

Hi ,
I never worked on XML part earlier. So please help me in extracting mentioned XML file

BI-RMA · Post by **BI-RMA** » Tue Oct 09, 2012 3:29 am

Online-help contains a Section InfoSphere DataStage and QualityStage --> Reference -->XML-transformation containing a tutorial for the XML-Stage contained in IBM Information Server from version 8.5 FP1.

eostic · Post by **eostic** » Tue Oct 09, 2012 5:49 am

What everyone is saying here is to just follow the doc and give it a shot...the xml above is actually very straightforward and an excellent one to start with when learning about the various xml stages. Hint --- you'll need a table definition, and for this, the xmlInput Stage will be fine..... and spend more time doing searches thru the forum here. There are many threads that discuss xml, how to read it from disk, what to specify in the Stages, etc.

Ernie

eostic · Post by **eostic** » Tue Oct 09, 2012 5:55 am

I take that back. Sorry --- the xml that you have pasted up above is not legitimate xml. There needs to be an element name collecting the various attributes for each "name" line.

Did you cut and paste this from somwhere or type it in manually?

<Employee Place="USA" Status="Active" Date="2012-09-30">
<Name="AAA" No="1" Grade="B" />
<Name="BBB" No="2" Grade="D" />
<Name="CCC" No="3" Grade="F" />
</Employee>

Look carefully at the source again. It "should" be easy, but not in this format.

A good tricks to always try:

...put a string like that in an editor, like Notepad and add an xml header line at the top....

<?xml version="1.0" ?>

...then try to open it in IE or other favorite browser. You'll see that this one dies. It is not well-formed.

The problem is the attribute lines...the probably should be something like:

<EmployeeDetail Name="AAA" No="1" Grade="B" />

Ernie