Discussion Board for collaboration on QlikView Scripting.
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 TblNameTablesize_Gb;SQL SELECT Run_Date, DatabaseName, Tablename, Tablesize_GbFROM "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
Go to Solution.
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.
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 .
see the below code.i think u missed comma in load statement
Month(Run_Date) AS Month_Name,