topic Re: Error while loading data in QlikView

Error while loading data

nikhilgarg — Mon, 09 Mar 2015 09:25:34 GMT

I am writting following script but it is giving me error:

Oledb Connection....

Table1:

SQL Select * , count(uid) as Col1 From [db1],[dbo].[tablename] With (NOLOCK) where servicename = 'abc' and username = 'def' ;

THankx

Re: Error while loading data

PrashantSangle — Mon, 09 Mar 2015 09:32:33 GMT

Hi,

Can you post the error, Which you are getting.

Regards

Re: Error while loading data

Mon, 09 Mar 2015 09:40:11 GMT

Hi Nikhil,

You didn't mention what kind of error your getting.

Please see the common Error and it codes..

ERROR CODE -

0 -No Error

1 -General Error

2 -Syntax Error

3 & 4 -ODBC/OLEDB Error

8 - File Not Found Error

Re: Error while loading data

nikhilgarg — Mon, 09 Mar 2015 10:16:33 GMT

It is giving error:

'db1.dbo.tablename.servicename'is invalid in select list becoz it is not contained in either an aggregate fn or group by clause.

Re: Error while loading data

nikhilgarg — Mon, 09 Mar 2015 10:18:43 GMT

It is giving error:

'db1.dbo.tablename.servicename'is invalid in select list becoz it is not contained in either an aggregate fn or group by clause.

Re: Error while loading data

manideep78 — Mon, 09 Mar 2015 10:22:23 GMT

Hi Nikhil,

You are using the aggregation function along with other columns(here the other columns are all columns that are represented by *). so include all other columns in group by clause.

SQL Select * , count(uid) as Col1 From [db1],[dbo].[tablename] With (NOLOCK) where servicename = 'abc' and username = 'def'

group by col1, col2....;

Re: Error while loading data

chrislofthouse — Mon, 09 Mar 2015 10:23:02 GMT

You need add a 'group by clause' at the bottom of your query for the fields you are selecting.

Re: Error while loading data

awhitfield — Mon, 09 Mar 2015 10:28:58 GMT

As you are select * , you need to add all other columns being select in a group by clause, you would much better off selecting the actual columns you want and group by those and NOT using *

This is an SQL error , not a Qlikview one.

Andy