I have several datasources which I want to merge. DataMart seems to be able to do this by pulling in each datasource as a Table and then make a query with Combine -> Append Queries.
How do I do something with the result of that query? It does not seem I can use that query as the input to anything else, I was expecting it would appear directly in the Report's Data view.
There is no way. This feature is pretty much useless until we can have those queries as views and use them with our tables.
Hi @siredman
The output from a datamart query is to be used in a report or can be consumed into another merge or append table?
What are you looking to do with the output from the datamart?
Thanks for your reply.
I would like to use the output of the query in my report, but in my report's Data tab I only see the raw tables.