Store into QVD Fail

[#1]

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

[MK_QSL · Accepted solution]

//OUTGOING:

NoConcatenate

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

[maxgro]

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

[#4]

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.

[VishalWaghole]

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.