Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Is it possible to store a QVD of crosstable output?

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.

1 Solution

Accepted Solutions

Re: Is it possible to store a QVD of crosstable output?

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

7 Replies

Re: Is it possible to store a QVD of crosstable output?

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

Not applicable

Re: Is it possible to store a QVD of crosstable output?

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

Re: Is it possible to store a QVD of crosstable output?

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

Not applicable

Re: Is it possible to store a QVD of crosstable output?

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

Not applicable

Re: Is it possible to store a QVD of crosstable output?

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

Re: Is it possible to store a QVD of crosstable output?

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

Re: Is it possible to store a QVD of crosstable output?

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

Community Browser