Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error in load statement..plz help

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

error loading image

Can you please help

Arif

Tags (2)
1 Solution

Accepted Solutions

Error in load statement..plz help

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.

3 Replies
deepakk
Valued Contributor III

Error in load statement..plz help

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

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.

Not applicable

Error in load statement..plz help





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



Community Browser