Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.

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;