topic UNION ALL in SELECT Statement in QlikView

UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 09:44:03 GMT

Hi all,

Please advise on UNION All in Select query,How to use:

Select

Details1 as Details,

From A

UNION ALL

Select

Details2 as Details,

From B;

Above statement is not working in load script.

I want to extract data with a select statement

for performance tuning.

Thanks for help

Nitha

Re: UNION ALL in SELECT Statement

ashfaq_haseeb — Wed, 20 Aug 2014 09:47:04 GMT

Use Concatenate

Replacement for union

Select

Details1 as Details,

From A

concatenate

Select

Details2 as Details,

From B;

Regards

ASHFAQ

Re: UNION ALL in SELECT Statement

ecolomer — Wed, 20 Aug 2014 09:47:09 GMT

It is possible you ODBC non suport this.

Try with JOIN or CONCATENATE

Re: UNION ALL in SELECT Statement

rajeshvaswani77 — Wed, 20 Aug 2014 09:49:50 GMT

Nitha,

Try the query first directly on the backed and see if it works?

What error message are you getting?

thanks,

Rajesh Vaswani

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 09:49:56 GMT

Hi Ashfaq,

I want to extract data from multiple tables with select statement at the same time so data will be extracted in single table to qlikview.

so concatenate can be done only after extracting all tables to qlikview.

Thanks

Nitha

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 09:51:17 GMT

Hi Rajesh,

Yes i have queried in backend and used same query in qlikview script.

But still it doesn't work

Thanks

Nitha

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 09:52:00 GMT

There is no error and only first table is extracted

Re: UNION ALL in SELECT Statement

rbecher — Wed, 20 Aug 2014 09:54:58 GMT

What is the source database system?

- Ralf

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 09:56:03 GMT

Hi Ralf,

Its oracle.

Re: UNION ALL in SELECT Statement

rajeshvaswani77 — Wed, 20 Aug 2014 09:56:17 GMT

Check if you have given SQL and terminated with quote. Otherwise it should work. Could be possibly to do with the driver then.

thanks,

Rajesh Vaswani

Re: UNION ALL in SELECT Statement

jonathandienst — Wed, 20 Aug 2014 09:58:21 GMT

Ashfaq has correctly answered your post. Concatenate the correct Qlikview syntax for a union. Did you even try it?

If this is not correct, then you may need to ask the question in other words, with much more detail.

Re: UNION ALL in SELECT Statement

rbecher — Wed, 20 Aug 2014 10:03:57 GMT

Can you post the full statement. I see empty lines in the post above but this shouldn't be a problem..

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 10:04:30 GMT

Yes i have used concatenate,but it doesn't solve issue,like i said performance tuning.

database has millions of rows and dashboard is very slow,so i am trying to extract multiple(10) tables

with same column names to qlikview.

so if i extract with single sql statement , it might reduce data.

Thanks

Nitha

Re: UNION ALL in SELECT Statement

rbecher — Wed, 20 Aug 2014 10:05:33 GMT

..but could be the cause.

Re: UNION ALL in SELECT Statement

jagan — Wed, 20 Aug 2014 10:09:17 GMT

Hi,

What is the error you are getting? If query runs in Oracle then it definitely run in Qlikview also.

Regards,

Jagan.

Re: UNION ALL in SELECT Statement

rbecher — Wed, 20 Aug 2014 10:12:48 GMT

No necessarily, it's ODBC or OLE DB inbetween...

Re: UNION ALL in SELECT Statement

Wed, 20 Aug 2014 10:17:05 GMT

Hi Nitha,

First check with single query whether the connection is working or not. Whenever you are using set operators both queries must have same number of columns and same data types.

regards,

Vijayreddy

Re: UNION ALL in SELECT Statement

ashfaq_haseeb — Wed, 20 Aug 2014 10:17:53 GMT

Hi,

Try by loading all tables in qvd and then later perform concatenate on qvd.

Or else you can use oracle specific query after you made connection to your database.

Regards

ASHFAQ

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 10:27:06 GMT

Hi Ralf,

Below is sql statement i am using:

SELECT
Details1 as Details,
CONTROL_KEY ,
PKEY,
LKEY,
'1’ as Identifier
From RSID
UNION ALL
SELECT
Details2 as Details,
CONTROL_KEY ,
PKEY,
LKEY,
'2' as Identifier
FROM RSIF
UNION ALL
SELECT
Details3 as Details,
CONTROL_KEY ,
PKEY,
LKEY,,
'3' as Identifier
FROM RSIG

Only first select is getting highlighted

Re: UNION ALL in SELECT Statement

Anonymous — Wed, 20 Aug 2014 10:29:09 GMT

Its ODBC