INFORMATICA | The Data Integration Company

Hi

I am getting HTTP response in the form of XML report.

xxx
yyy
zzz

xx
yy
zz

I am parsing XML using XML parser.

Output is like this

page_num row_num col_num data
1 1 1 xxx
1 1 2 yyy
1 1 3 zzz
1 2 1 xx
1 2 2 yy
1 2 3 zz

What I want is

page_num row_num col_name1 col_name2 col_name3

1 1 xxx yyy zzz
1 2 xx yy zz

Number of rows will change every day. I know number of columns.

Need to know how can i achieve this

Abhishek