Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Just a quickie...is it possible to load data from a Union Query within MSAccess??
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
we can achieve this using join
load * from first query
join
Load * from second query
this might helps you
I think we can achieve this by concatenating two tables with keyword distinct.
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