on 03-07-2007 2:53 PM
How come when I build a UNION action in BLS and test it using either the XML query or Xacute query, I see two tables? When I go to use this data, will I be able to treat this data as if it is one table like SQL would allow me?
Regardless of what you see when you test the query, the applets will still treat it as a single table, typically.
- Rick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can try this approach also.
If you want to merge two tables than also you can use joiner action block.
There is option to join as inner or outer join.So this way single output will come.
Best Regards
Ramshanker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The UNION action block will create two Rowsets of data. This is why you are seeing two HTML tables when you test the Query.
I am assuming both HTML tables have the same columns. If you really want these two tables as one table, you probably don't want to use the Union block but instead a Repeater that adds rows to a separate IllumDoc.
On the output side, you can specify which Rowset to use in a display template buy filtering with XPATH in a style sheet like \Rowsets\Rowset[2]\Row\item.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
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.