Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have some issue in saving part of my data in qvd files. Basically I am trying to use something like this:
//
dan:
load * inline
[
numero, DA,rate
1,Goldorak,good
2,Candy,bad
3,DBZ,good
4,DBGT,bad
4,Booba,good
5,Nicky Larsson,good
6,Bugs Bunny,good
7,Captain Flam,good
8,Albator, good,
9,Avatar ANG,good
10,Avatar Kora,bad
] ;
dan2:
NoConcatenate
load *
resident dan
where rate='bad';
store dan2 into
//
this example runs perfectly, but the exact same based on real data doesn't work for reasons I don't get: everything is processed and I am ending with the message: "excecution of script failed. Reload old data?" I unsuccessfully tried the solution in General Script Error storing a QVD; so can you please help me with some explicit exemple. Thanks. Pierre
Dear all,
Sorry for having disturbed with my issue: I reviewed more than 10 times but It was a damned typo error. there were no locked file inexisting directory or anything like that.
Now, if I mistype a column name of a qliktable, I'll get an error like "field not found", so I know exactly where I have to go to make the correction. Is it possible to get a specific message where he code is referring to a directory that doesn't exist ?
Regards,
Pierre
Try
store dan2 into
Hi Pierre,
you have missed the (qvd) off after .qvd]
HTH Andy
Swuehl, Andrew,
the code above runs perfectly even without the (qvd); I unfortunately can't publish what doesn't work because these are professional data. But how do we deal with such issue (not being able to store a qvd file) when it ever happened to you ?
can you please share the real time data script ?? that would help us in tracing the issue
What's the difference between your two settings except the data source? Are you trying to store to a different location? If the location is not accessible (e.g. read-only) by the user that runs the script, you will get the same error.
Hi Pierre,
are You sure exists Directory C:\Examples ?
(qvd) is default.
Regards,
Antonio
Is the directory really exists "C:\Examples\"? check if it is available or not
sounds like it could be file locking, does the QVD already exist and you are trying to replace it? Rename/Delete the QVD or check Windows computer management for open files.
hope that helps
Joe
Dear all,
Sorry for having disturbed with my issue: I reviewed more than 10 times but It was a damned typo error. there were no locked file inexisting directory or anything like that.
Now, if I mistype a column name of a qliktable, I'll get an error like "field not found", so I know exactly where I have to go to make the correction. Is it possible to get a specific message where he code is referring to a directory that doesn't exist ?
Regards,
Pierre