topic Re: Autonmuber in load statement in QlikView

Autonmuber in load statement

Anonymous — Thu, 10 Dec 2015 08:43:27 GMT

Hi,

I am trying to add function in SQL Load statement, but it is not recognizing here.

Please help me in this.

Regards,

Kumar

Re: Autonmuber in load statement

tresB — Thu, 10 Dec 2015 08:48:39 GMT

Autonumber() is qv function that can't be used as SQL command. Try like:

Load

Autonumber(Field) as Newfield;

SQL Select Field, ....;

Re: Autonmuber in load statement

Anonymous — Thu, 10 Dec 2015 08:55:33 GMT

Thanks for giving suggestion. Please see the screen shot after changing this one.

I am not getting where it is going wrong.

Regards,

Kumar

Re: Autonmuber in load statement

MayilVahanan — Thu, 10 Dec 2015 08:57:56 GMT

Try like this

Load *,

Autonumber(lead_id&time_Month_Key) as Num ;

Sql select statement;

Re: Autonmuber in load statement

maxgro — Thu, 10 Dec 2015 08:59:53 GMT

load

autonumber(.........) as num;

SELECT

......

;

Re: Autonmuber in load statement

Anonymous — Thu, 10 Dec 2015 09:03:57 GMT

Thanks a lot Mayil .

I have one more doubt.

can't we write where not exists at the end of SQL statement.

Regards,

Kumar

Re: Autonmuber in load statement

tresB — Thu, 10 Dec 2015 09:08:22 GMT

Again exists() is a qv function; can't be used in SQL.

Re: Autonmuber in load statement

jagan — Thu, 10 Dec 2015 09:08:59 GMT

Hi,

You can write any SQL statement in Qlikview, before using in Qlikview first verify the query in database.

Regards,

jagan.

Re: Autonmuber in load statement

Anonymous — Thu, 10 Dec 2015 09:16:23 GMT

Hi,

Can you tell me how to write this where not exists in this statement.

Regards,

Kumar

Re: Autonmuber in load statement

MayilVahanan — Thu, 10 Dec 2015 09:20:55 GMT

Try like this

Load * where not exists(Field1, Field2);

Sql select statement;

Where not Exists and Exits

Re: Autonmuber in load statement

Anonymous — Thu, 10 Dec 2015 09:48:10 GMT

Thanks a lot Mayil