topic Can you load from a Union Query?? in QlikView

Can you load from a Union Query??

samvile18 — Tue, 10 Jan 2012 12:03:18 GMT

Hi everyone,

Just a quickie...is it possible to load data from a Union Query within MSAccess??

Can you load from a Union Query??

SunilChauhan — Tue, 10 Jan 2012 12:31:53 GMT

we can achieve this using join

load * from first query

join

Load * from second query

this might helps you

Can you load from a Union Query??

vijay_iitkgp — Tue, 10 Jan 2012 12:36:10 GMT

I think we can achieve this by concatenating two tables with keyword distinct.

Can you load from a Union Query??

Miguel_Angel_Baeyens — Tue, 10 Jan 2012 13:59:25 GMT

Hi,

The short answer is yes. Since the SQL part is not evaluated by QlikView other than passed on to the driver, should MSAccess is able to interpret the union query QlikView will load all rows properly. You can easily check that using the Select.. button in the Edit Script window. You can see there all available tables and views (queries) and fields in each of them.

Another option, as Sunil suggests above is doing the UNION in QlikView, based on two separate SQL statements.

Hope that helps.

Miguel