Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV version problem: can't reload

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 🙂

4 Replies
Not applicable
Author

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?

Not applicable
Author

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

prieper
Master II
Master II

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
Not applicable
Author

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