Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
What is the script that you are using? What is the error? Please share that information to help you better
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
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);
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
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
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);
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);