xml help

[riteshskumar]

Hi Guys -- need a small help in processing one xml doc in "Get data from XML" step. PDI Version - 4.2.1


source file is:-

<case>
        <win id="SpeakToPatient">
            <data>I just woke up and I couldnt breathe.  </data>
            <data> I feel a little better.  </data>
            <data>Thanks, I feel a lot better now.  </data>
        </win>
        <win id="IV Pump">
            <data>Normal Saline 50 cc/hr</data>
            <data>Normal Saline 60 cc/hr</data>
            <data>Normal Saline 70 cc/hr</data>    
        </win>
</case>

I am expecting output in two columns 3 rows. like:-

"I just woke up and I couldnt breathe.", "Normal Saline 50 cc/hr"
"I feel a little better.", "Normal Saline 50 cc/hr"
"Thanks, I feel a lot better now.", "Normal Saline 50 cc/hr"

Request you to please take a brief look and help me out to solve it. Any help will be highly appreciated.

Regards,
Ritesh

[riteshskumar]

Guys -- ignore it. I have found solution using correct xpath.

//win[@id='SpeakToPatient']/data[1]
//win[@id='SpeakToPatient']/data[2]
//win[@id='SpeakToPatient']/data[3]

Ritesh