Merge or union the results from two visuals using the same query

Question

I have two table visuals that have two similar columns ( the column names are different). The first two visuals have different filters. I want to merge or union the two visuals into one table visual. I don't want to duplicate the query if its avoidable since the queries run long. Is there a way to merge the two visuals?&nbsp; Thanks&nbsp;Table visual 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table visual 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Desired resultsName&nbsp; &nbsp; &nbsp; ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Name&nbsp; &nbsp;Num&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp;NumberMary&nbsp; &nbsp; &nbsp; 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mark&nbsp; &nbsp; 9999&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mark&nbsp; &nbsp; 9999&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mary&nbsp; &nbsp; 1000&nbsp;&nbsp;

lbendlin · Answer

You can UNION them (the result would use the column names of whatever comes first, or you can do a SELECTCOLUMNS first to change column names.
&nbsp;
In either case that table query needs to be materialized into a Calculated Table which means it won't be dynamic any more.

anonymous · Answer

Lbendin, Can you provide an example. It's not clear to me as to how to union them.

lbendlin · Answer

see attached.
&nbsp;

anonymous · Answer

Thanks for the example. I'm getting data from just one table and displaying it in two visuals. I was hoping to be able to merge the data from the two visuals to create the the third visual. Does your method accomplish this without using two tables?&nbsp;

lbendlin · Answer

sounds like I totally misunderstood what you are trying to achieve.&nbsp; Are you saying you want to combine three columns into two?

Forum Discussion

Merge or union the results from two visuals using the same query

8 Replies

Related content

MERGE QUERIES

Issue with Merge giving null result

Async merge risk

Data to be merged on Visual Level

Merge statement creates duplicates - Low shuffle merge as cause?