topic STORE help in QlikView

STORE help

Anonymous — Wed, 13 May 2015 23:59:25 GMT

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.

Re: STORE help

danieloberbilli — Thu, 14 May 2015 00:28:49 GMT

you need a (qvd) at the end:

Store Lockbox2 INTO (qvd);

Re: STORE help

simospa — Thu, 14 May 2015 07:27:12 GMT

Hi, I tried with relative path and it works, even without (qvd).

To have your same issue I try to use E:\ to store (and I haven't E:\ unit in my disk).

So I think you'd better to check your path. Try to use another path and let us know.

PS: another curious thing is that you are defining a Lockbox2 and in the log I see you are storing Lockbox, but I think it is a copy/paste misprint.

Re: STORE help

mohammadkhatimi — Thu, 14 May 2015 07:35:20 GMT

Store Lockbox2 INTO E:\Data\Close Improvement\Dashbaord\MEC Snapshot\QVD\Lockbox.QVD (qvd);

Remove bracket from the path or do give properly path by copying from title bar.

Try this.

Regards,

Mohammad

Re: STORE help

buzzy996 — Thu, 14 May 2015 08:10:56 GMT

the best way is,

define ur path with varibale like below,

SET QVDPath ="D:\XXXXX";

and use that varible "QVDPath " in store command,like below.

STORE URTABLENAME INTO [$(QVDPath)\XXX_QUALITY.qvd];

Re: STORE help

qlikviewwizard — Thu, 14 May 2015 08:23:16 GMT

Hi Use this,

Path='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 Lockbox2 INTO [$(Path)Lockbox.QVD];

Re: STORE help

jonathandienst — Thu, 14 May 2015 08:46:54 GMT

Its possible that the file is locked. You can test that by attempting to change the file name (assuming you have write access).

This is usually caused by multiple processes attempting to write to the file, or a failed process that retained a lock on the file. Look for qv.exe (desktop) and qvb.exe (server/publisher batch reload) processes in the task manager. If you know that a process has failed, then you can kill it from the teak manager.

Re: STORE help

Anonymous — Fri, 15 May 2015 13:05:00 GMT

Thank you for the help!

I was able to get it working with setting a few variables:

SET QVDFILE=E:\Data\Close Improvement\Dashbaord\MEC Snapshot\QVD\Bank.qvd;

LET datatable='Bank';

STORE $(datatable) INTO $(QVDFILE);

Re: STORE help

petter — Fri, 15 May 2015 13:32:10 GMT

You still HAVE to supply (QVD) at the end of the STORE statement before the semicolon - or you will get a text file not a QVD. It doesn't matter that your name your file .qvd....

It has been pointed out by others in earlier posts on this thread... But judging by your last post you haven't noticed...

Re: STORE help

Anonymous — Fri, 15 May 2015 13:50:26 GMT

Thank you Peter!

I have added to the STORE statement

STORE $(datatable) INTO $(QVDFILE)(qvd);

Re: STORE help

Anonymous — Fri, 15 May 2015 14:16:30 GMT

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;