topic Re: Script fails to reload when renaming fields in edit script in QlikView

Script fails to reload when renaming fields in edit script

Wed, 13 Aug 2014 20:14:22 GMT

Hi everyone,

I am hoping this is a simple one where I am just overlooking a detail. I have a simple QVW created from a single QVD with a straight table and a bunch of filters. All I am trying to do is go into my edit script and change fields into proper case with spaces:

Example:

load

cust_cnt as "Customer Count",

second_field,

third_field

from c:\file.qvd;

I have tried using quotes and brackets like [Customer Count], and neither work. In all instances, I get the "Execution of script failed. Reload old data?" error. Has anyone else encountered this issue?

Thanks for any help you can offer!

Re: Script fails to reload when renaming fields in edit script

simenkg — Wed, 13 Aug 2014 20:18:25 GMT

first of all you have to specify the format of the file from c:\file.qvd (qvd);

If you get no other error message but the script failes like you said, then there is usually an error with a locked file. Are you trying to save the table in the line under to a folder that does not exist or to a file that is readonly/in use?

the correct syntax is cust_cnt as [Customer Count],

Re: Script fails to reload when renaming fields in edit script

MarcoARaymundo — Wed, 13 Aug 2014 20:20:08 GMT

change quotes like this: "Customer Count" -> [Customer Count]

Re: Script fails to reload when renaming fields in edit script

aveeeeeee7en — Wed, 13 Aug 2014 20:23:19 GMT

Are you storing this table in some qvd.

Regards

Aviral Nag

Re: Script fails to reload when renaming fields in edit script

Anonymous — Wed, 13 Aug 2014 20:24:00 GMT

square brackets is the right syntax. remove the double quotes and replace them with square brackets and i think you are missing (qvd) after filename...something like:

load

cust_cnt as [Customer Count],

second_field,

third_field

from c:\file.qvd (qvd);

ps: bwisenoSimenKG beat me to it

Re: Script fails to reload when renaming fields in edit script

Wed, 13 Aug 2014 20:28:52 GMT

Thank you for all the replies! The double quotes had worked for me previously, but even with brackets I was getting that error. I ended up clearing a bunch of objects from the sheet, and that seemed to solve the problem, so there must have been an issue with an object using the old naming convention, then breaking when I tried to update the naming convention. I appreciate everyone who chimed in on this one!

Re: Script fails to reload when renaming fields in edit script

maxgro — Wed, 13 Aug 2014 20:31:54 GMT

load

cust_cnt as "Customer Count",

second_field,

third_field

from c:\file.qvd (qvd);

to rename a field you can use

cust_cnt as "Customer Count"

cust_cnt as 'Customer Count'

cust_cnt as [Customer Count]

Re: Script fails to reload when renaming fields in edit script

MarcoARaymundo — Wed, 13 Aug 2014 20:51:46 GMT

please, change te status to answered.