cancel
Showing results for 
Search instead for 
Did you mean: 

UNIONS - XML lists two tables

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Regardless of what you see when you test the query, the applets will still treat it as a single table, typically.

- Rick

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

I think a joiner would defeat the purpose as I am trying to stack data on top of each other instead of adding columns to my query.

Former Member
0 Kudos

Hi

If joiner is not suitable for purpose than take Union.

After doing union if you run xcute query ,it will show you two tables but you can show this result in single Grid.

How you want to display result ?

Best Regards

Ramshanker Upadhyay

Former Member
0 Kudos

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.