topic QV version problem: can't reload in QlikView

QV version problem: can't reload

Fri, 08 Apr 2011 09:08:38 GMT

Hi,

I made a qvw in QV 10 SR1 without any problems but another user from my company opened the file in QV 9 SR6 and couldn't reload. I found out that if i use an asterix in the filename it doesn't want to reload but if i use the full path is does... Can i fix this?


LOAD
*
FROM
data\bfte*.xlsx
(ooxml, no labels, header is 1 lines, table is Blad1)

This doesn't work it gives an 'execution of script failed' error.


LOAD
*
FROM

(ooxml, no labels, header is 1 lines, table is Blad1)

This works... but that's just 1 file and there are more

pls help 🙂

QV version problem: can't reload

Fri, 08 Apr 2011 09:25:01 GMT

mmm weird i think it depends on the type of file cause i just tried to reload another file:


LOAD *
FROM

(biff, no labels, table is Blad1$);

This is a biff type of file and then i can use an * in my filename, QV9 SR6 isn't supporting asterikses for ooxml?

QV version problem: can't reload

Fri, 08 Apr 2011 09:41:54 GMT

mmm no ain't that either 😛 don't really know now what the problem is cause i can use an asteriks in other xlsx files. weird

QV version problem: can't reload

prieper — Fri, 08 Apr 2011 12:55:30 GMT

Think that w/in the same directory you need to preceed with ".\".
Would also recommend to enclose the file-name with square brackets,

thus your script should read.

LOAD<pre>*
FROM
[.\data\bfte*.xlsx]
(ooxml, no labels, header is 1 lines, table is Blad1)

HTH
Peter

QV version problem: can't reload

Fri, 08 Apr 2011 13:03:23 GMT

yeah i knew, the problem was that some files were corrupt. In QV 9 SR6 it couldn't read them but in 10 SR1 it could. I copy pasted the data to another file and it worked 🙂 strange