Is it possible to store a QVD of crosstable output?

[#1]

I have a wide table (100 columns, 10 million rows). The crosstab takes a long time to complete. When I try to store the resultant [tablename]-1 for optimised QVD loading I get an error. I was hoping this might be a way to reduce load times.

[sunny_talwar]

What is the script that you are using? What is the error? Please share that information to help you better

[#3]

The script is:

LOAD * FROM 'C:\IMS\crossed.qvd'(qvd);

CrossTable (Week,TRx)

load * resident Bins;

STORE Bins-1 into 'C:\IMS\binsx.qvd' (qvd);

The error is incorrect FROM syntax.

Thanks,

Paul

[sunny_talwar]

Try without single quotes:

Bins:

LOAD *

FROM C:\IMS\crossed.qvd (qvd);

Bins-1:

CrossTable (Week,TRx)

LOAD *

Resident Bins;

STORE Bins-1 into C:\IMS\binsx.qvd (qvd);

[#5]

Hi Sunny T,

Thanks but I still get the same error message (without the single quotes):

Syntax error, missing/misplaced FROM:

STORE Bins-1 into C:\IMS\binsx.qvd (qvd)

STORE Bins-1 into C:\IMS\binsx.qvd (qvd)

Regards,

Paul

[#6]

Hi

Sunny T,

I did some more searching around the forum and realised I needed to prevent evaluation of that tablename (Bins-1), it needs to go inside [].

Thanks anyway,

Paul

[Kushal_Chawda]

try this

Bins1:

LOAD * FROM 'C:\IMS\crossed.qvd'(qvd);

Bins:

CrossTable (Week,TRx)

load * resident Bins1;

drop table Bins1;

STORE Bins into 'C:\IMS\binsx.qvd' (qvd);

[settu_periasamy · Accepted solution]

Hi,

The Bins-1 should be within Square Bracket becauase of -1 .

Try Like

LOAD * FROM 'C:\IMS\crossed.qvd'(qvd);

CrossTable (Week,TRx)

load * resident Bins;

STORE [Bins-1] into 'C:\IMS\binsx.qvd' (qvd);