Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

STORE help

I am trying to do a simple store to an existing QVD, but am getting a "general Script Error".

Here is the script:

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';

Lockbox2:

LOAD DATE,

     DIFFERENCE,

     [Reconcilation Time],

     maxdate

FROM

[..\Data\Close Improvement\Dashbaord\MEC Snapshot\Data\Bank_Lockbox2.xlsx]

(ooxml, embedded labels, table is [Sheet1 (2)]);

Store Lockbox2 INTO ;

Logfile Error:

STORE Lockbox INTO [E:\Data\Close Improvement\Dashbaord\MEC Snapshot\QVD\Lockbox.QVD

General Script Error

Execution Failed

Execution finished.

Labels (1)
10 Replies
Anonymous
Not applicable
Author

try.

SET vPath='E:\Data\Close Improvement\Dashbaord\MEC Snapshot\QVD\'

Lockbox2:

LOAD DATE,

     DIFFERENCE,

     [Reconcilation Time],

     maxdate

FROM

[..\Data\Close Improvement\Dashbaord\MEC Snapshot\Data\Bank_Lockbox2.xlsx]

(ooxml, embedded labels, table is [Sheet1 (2)]);

STORE * FROM Lockbox2  INTO $(vPath)Lockbox.QVD;

Drop table Lockbox2;