topic Qlikview Reload in QlikView

Qlikview Reload

qlik_venu — Sat, 21 Aug 2010 19:22:27 GMT

Hi,

I had received a Qlikview file in which a Table [Sample]: was created using the LOAD statement. It has the ODBC connect syntax to connect to the db.

But when i added one more table sysdate1, the RELOAD fails with a statement, Field not found error.

What are the steps i need to follow when I add to the existing table loads in the RELOAD script.

Follwing is the Reload script I Used,

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

ODBC CONNECT TO GDWPRD (XUserId is YCUZVRdNHTdSWSdOVbcAG, XPassword is TTVeJZVMBDZADXFGZDIYG);

[SAMPLE]:
LOAD
ROW_DATE,
SPLIT,
ANSTIME,
ANSTIME_AVG,
SERVICE_LEVEL;
SQL SELECT ROW_DATE
, SPLIT
, ANSTIME
, ANSTIME_AVG
, SERVICE_LEVEL
FROM SMKDM."CS_CMS_DSPLIT_F";ODBC CONNECT TO GDWPRD;

sydate1:
load
current_day;
SQL select sysdate from dual;

The script fails at the start of execution of the 2nd table sysdate1`. Why should this happen. The first tables gets loaded fully and fails only at the 2nd.

Also attached the snapshot.

Thanks,

Venu

Qlikview Reload

vgutkovsky — Sat, 21 Aug 2010 22:01:09 GMT

Change it to something like the following:


sydate1:
LOAD
 sysdate as current_day;
SQL select sysdate from dual;

You need to alias the field that your SQL statement originally fetches.

Regards,

Qlikview Reload

Sat, 21 Aug 2010 22:03:27 GMT

Appears to me that it is failing becasue current_day is not defined in the sql select statement.

You would need to alias the sysdate field in teh sql select e.g.

sydate1:
load
current_day;
SQL select sysdate as current_day from dual;

edit: Vlad got there first

Qlikview Reload

vgutkovsky — Sat, 21 Aug 2010 22:06:43 GMT

SQL-Cowboy, your signature is excellent!

Qlikview Reload

Sat, 21 Aug 2010 22:42:16 GMT

Why thank you, you're too kind!

Qlikview Reload

montubhardwaj — Sun, 22 Aug 2010 19:08:40 GMT

Hi,

You need to alias the filed in Select to match as in the Load. You can follow as below:

sydate1:
load
current_day;
SQL select sysdate as current_day

from dual;

Hope it will solve your issue.

Cheers!!!

Sharma