topic Error in load statement..plz help in QlikView

Error in load statement..plz help

Wed, 02 Mar 2011 12:49:44 GMT

Hello,

I am using the following code

ODBC CONNECT TO UCPROD;

V_QV_Table_Size:
Load Run_Date,
Month(Run_Date) AS Month_Name,
DatabaseName as DBname,
Tablename as TblName
Tablesize_Gb;
SQL SELECT
Run_Date,
DatabaseName,
Tablename,
Tablesize_Gb

FROM "D_SYSTEM_LOGS"."V_Table_Size"
WHERE
Run_Date(Date)=Date-1;

store V_QV_Table_Size into V_QV_Table_Size.qvd;

It is given the following error

Can you please help

Arif

Error in load statement..plz help

deepakk — Wed, 02 Mar 2011 13:03:21 GMT

hi Syed,

I think there is something wrong in WHERE
Run_Date(Date)=Date-1;

As i understand from the script Run_Date is a field name .

Error in load statement..plz help

Miguel_Angel_Baeyens — Wed, 02 Mar 2011 13:04:37 GMT

Hello Arif,

It seems that you missed a comma after this field:

Tablename as TblName,

Usually those "missing/misplace FROM" errors are because of wrong number of commas as field separators.

Hope that helps.

Error in load statement..plz help

Wed, 02 Mar 2011 13:16:08 GMT

Hi,

see the below code.i think u missed comma in load statement

V_QV_Table_Size:

Load

Run_Date,

Month(Run_Date) AS Month_Name,

DatabaseName

as DBname,

Tablename

as TblName,

Tablesize_Gb;

SQL

SELECT

Run_Date,

DatabaseName,

Tablename,

Tablesize_Gb

FROM

"D_SYSTEM_LOGS"."V_Table_Size"

Regards,

Chandra