Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Can you load from a Union Query??

Hi everyone,

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

3 Replies
SunilChauhan
Champion
Champion

we can achieve this using join

load * from first query

join

Load * from second query

this might helps you

Sunil Chauhan
vijay_iitkgp
Partner - Specialist
Partner - Specialist

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

Miguel_Angel_Baeyens

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