Combining Rowsets into one row

[Former Member]

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

[jcgood25]

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]

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

[agentry_src]

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]

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]

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

[Former Member]

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]

Namita

You can simply use the Joiner Action Block ,

Hope this helps