XML output formatting

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kapil_nj
Participant
Posts: 14
Joined: Mon Aug 02, 2010 7:47 am
Location: nj

XML output formatting

Post by kapil_nj »

i am getting the output message as
<parentinfo>
<personid>1
</personid>
<name>
<fn>micheal
</fn>
<ln>
johnson
</ln>
</name>
<age>40
</age>
</parentinfo>

<relatedstudent>
<stud_FN>james
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>
</relatedstudent>



<parentinfo>
<personid>2
</personid>
<name>
<fn>kevin
</fn>
<ln>scott
</ln>
</name>
<age>45
</age>
</parentinfo>

<relatedstudent>
<stud_FN>kelly
</stud_FN>
<stud_LN>
</stud_LN>scott
</stud_FN>
</relatedstudent>






<parentinfo>
<personid>1
</personid>
<name>
<fn>micheal
</fn>
<ln>johnson
</ln>
</name>
<age>40
</age>
</parentinfo>

<relatedstudent>
<stud_FN>linda
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>
</relatedstudent>

Required Format is : since 1st and 3rd person are same because of same person_id=1 so both related student should come under same person/tag.

<parentinfo>
<personid>1
</personid>
<name>
<fn>micheal
</fn>
<ln>
johnson
</ln>
</name>
<age>40
</age>
</parentinfo>

<relatedstudent>
<stud_FN>james
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>
<stud_FN>linda
</stud_FN>
<stud_LN>johnson
</stud_LN>
</stud_FN>

</relatedstudent>



<parentinfo>
<personid>2
</personid>
<name>
<fn>kevin
</fn>
<ln>scott
</ln>
</name>
<age>45
</age>
</parentinfo>

<relatedstudent>
<stud_FN>kelly
</stud_FN>
<stud_LN>
</stud_LN>scott
</stud_FN>
</relatedstudent>
samdsx
Premium Member
Premium Member
Posts: 19
Joined: Wed Aug 18, 2010 8:48 pm

Re: XML output formatting

Post by samdsx »

since it is in one parentinfo, you need to remove duplicate after reading complete file.
Post Reply