Hi...
I need to split table based on a tag value. Please refer the below code which is the input xml for me
<exception>
<funcid>Upld002</funcid>
<header>Test1</header>
<rec>Rec001</rec>
</exception>
<exception>
<funcid>Upld003</funcid>
<header>Test1</header>
<rec>Rec001</rec>
</exception>
<exception>
<funcid>Upld003</funcid>
<header>Test2</header>
<rec>Rec001</rec>
</exception>
From the above tags i'm generating table data with 3 columns as defined above.
My requirement is to split table for every <header> value
For the above example, i have to get 2 tables, first with two rows since <header> value is same for two <exception> tags and second with 1 row.
How can i accomplish this grouping? Can anyone help?