topic Re: Store into QVD Fail in QlikView

Store into QVD Fail

Fri, 05 Sep 2014 10:58:31 GMT

Hi,

I'm trying to store my data into QVD files. I have two separate sources (different excel tabs) from where I fetch my data. When i run the script everything is fine until the second store. I've tried to save both tables into the very same QVD file, however i still receive the below script error.

Any ideas?

Thanks in advance,

Olle

***************************************************************

Table not found

STORE Outgoing INTO E:\DataOutgoing.qvd (QVD)

***************************************************************

//INCOMING
Incoming:
LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount,

FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Incoming);
STORE Incoming INTO E:\DataIncoming.qvd (QVD);

//OUTGOING:
Outgoing:
LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount,

FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Outgoing);
STORE Outgoing INTO E:\DataOutgoing.qvd (QVD);

Re: Store into QVD Fail

MK_QSL — Fri, 05 Sep 2014 11:00:52 GMT

//OUTGOING:

NoConcatenate

Outgoing:
LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount,

Re: Store into QVD Fail

maxgro — Fri, 05 Sep 2014 11:01:34 GMT

add noconcatenate (bold)

from online help

The NoConcatenate prefix forces two loaded tables with identical field sets to be treated as two separate internal tables, when they otherwise would be automatically be concatenated.

//OUTGOING:
Outgoing:

noconcatenate
LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount,

FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Outgoing);
STORE Outgoing INTO E:\DataOutgoing.qvd (QVD);

Re: Store into QVD Fail

Fri, 05 Sep 2014 11:02:07 GMT

Use NoConcatenate in the second load.

Like,

Outgoing:

NoConcatenate
LOAD
     Date,
     OriginalTime,
     Reference,
     Type,
     SettlementAmount,

FROM
[DataLog\*.xls]
(ooxml, embedded labels, table is Outgoing);
STORE Outgoing INTO E:\DataOutgoing.qvd (QVD);

Hope this helps.

Re: Store into QVD Fail

VishalWaghole — Fri, 05 Sep 2014 11:37:49 GMT

Hi Olle,

Try this, I have commented some notes please follow that, Hope it will work for you.

Incoming:
LOAD Date,
OriginalTime,
Reference,
Type,
SettlementAmount, // after SettlementAmount , delete that one also
FROM
[DataLog\*.xls] // Try with absolute path of your excel
(ooxml, embedded labels, table is Incoming);

STORE Incoming INTO E:\DataIncoming.qvd (QVD);

Drop table Incoming; // Once Qvd generate then drop that table

Outgoing:
LOAD
Date,
OriginalTime,
Reference,
Type,
SettlementAmount, // after SettlementAmount , delete that one also
FROM
[DataLog\*.xls] // Try with absolute path of your excel
(ooxml, embedded labels, table is Outgoing);

STORE Outgoing INTO E:\DataOutgoing.qvd (QVD);

Drop table Outgoing; // Once Qvd generate then drop that table

-- Regards,

Vishal Waghole.