on 05-22-2008 1:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Namita
You can simply use the Joiner Action Block ,
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.