Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
TigerisBack
Champion
Champion

we can achieve this using join

load * from first query

join

Load * from second query

this might helps you

vijay_iitkgp
Partner
Partner

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

View solution in original post