topic Re: Error while loading script in QlikView

Error while loading script

Tue, 19 Feb 2013 05:47:23 GMT

Dear All

I am uploading an excel sheet which contains many data header starting with "["

for ex: [SPRJ] GPRO Involvement.

If I remove the character "[" manually then it loads the script.

The report coming out from the system contains starting character as "[".

Please suggest a solution to load the script with data header [SPRJ] GPRO Involvement

Best Regards

Rahul Kale

Re: Error while loading script

its_anandrjs — Tue, 19 Feb 2013 06:59:22 GMT

Hi,

It is because there is [ bracket start and end i suggest you if you load data with Explicit load and the in the load script rename the column name it works for you in this case if there is field like [SPRJ] GPRO loaded and then you rename it.

Regards,

Anand

Re: Error while loading script

hic — Tue, 19 Feb 2013 07:20:39 GMT

Explicit load would work, but it is not necessary.

Load "[SPRJ] GPRO" From ...

will work fine. I.e. use double quotes instead of brackets to quote the field.

HIC

Re: Error while loading script

Tue, 19 Feb 2013 11:01:52 GMT

Thanks Henric