Solved: Can you load from a Union Query?? - Qlik Community

samvile18 · ‎2012-01-10

Hi everyone,

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

Miguel_Angel_Baeyens · ‎2012-01-10

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

View solution in original post

SunilChauhan · ‎2012-01-10

we can achieve this using join

load * from first query

join

Load * from second query

this might helps you

Sunil Chauhan

vijay_iitkgp · ‎2012-01-10

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

Miguel_Angel_Baeyens · ‎2012-01-10

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