cancel
Showing results for 
Search instead for 
Did you mean: 

Combining Rowsets into one row

Former Member
0 Kudos

Hi All,

Can we combine Rowset 1 and Rowset2 into one row

As there are two rowsets and nothing is common between the two rowsets so i cant do normalization.The problem due to rowset is if one rowset returns only one row and other rowset returns two rows then in Grid it shows only one Row

Any method to eliminate this problem

Best Regards

Namita

Accepted Solutions (0)

Answers (2)

Answers (2)

jcgood25
Active Contributor
0 Kudos

Are Rowset1 and Rowset2 the same shape, meaning the columns are identical? The iGrid will not use Rowset2 if it is a different dataset shape than Rowset1.

Regards,

Jeremy

Former Member
0 Kudos

Hi Jeremy,

Yeah rowset 1 i totally different from rowset2 .Rowset1 is just the status check for BAPI and rowset 2 is items from BAPI

Regards

Namita

0 Kudos

Hi Namita,

It sounds like you need nested repeaters and an output document with columns for each field in the two rowsets. If I understand you correctly, something like this would work:

1. Create xMII XML Output Document with a column for each field of interest from Rowset 1 & 2.

2. Repeat on Rowset 1

3. Repeat on subset of Rowset 2 related to Rowset 1

4. Add Row to Document with data from each repeater.

5. Once you complete building your document, you can use it with an BLS (Xacute) query for the grid.

The difficulty for me is how you would determine the subset of Rowset 2 which is related to Rowset 1. Can you even do that? It may require some dynamic linking (xPath) to filter Rowset 2.

Hope this helps,

Mike

Former Member
0 Kudos

Hi Mike,

Both the rowsets are independent of each other . They are not related to each other.

RFC is returning output from 5 different table and i have to display the output in grid .

If i take union it is going to generate different rowsets which is not possible to display on grid .

Worst solution would be taking five different output xml and having 5 different query templates to display data in grid.

Can you suggest a better solution

Best Regards

Namita

Former Member
0 Kudos

Why not do the easier approach and have two grids??? Just turn the header off on the second grid.

Former Member
0 Kudos

Hi Rick

I have followed the same approach but concept of having two grid didnt sound too good so asked for a better solution

Thanks

Namita

Former Member
0 Kudos

Namita

You can simply use the Joiner Action Block ,

Hope this helps