Autonmuber in load statement

[Anonymous]

Hi,

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

Please help me in this.

Regards,

Kumar

[tresesco]

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

Load

          *,

          Autonumber(Field) as Newfield;

SQL Select Field, ....;

[Anonymous]

Hi

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

I am not getting where it is going wrong.

Regards,

Kumar

[MayilVahanan]

Hi

Try like this

Load *,

Autonumber(lead_id&time_Month_Key) as Num ;

Sql select statement;

[maxgro]

load

    *,

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

SELECT

    ......

    ;

[Anonymous]

Thanks a lot Mayil .

I have one more doubt.

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

Regards,

Kumar

[tresesco]

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

[jagan]

Hi,

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

Regards,

jagan.

[Anonymous]

Hi,

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

Regards,

Kumar

[MayilVahanan · Accepted solution]

Hi

Try like this

Load * where not exists(Field1, Field2);

Sql select statement;

Where not Exists and Exits