Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Load

Hey there,

I'm trying to load from server some TXT files.

They have the same structure and file name, just change the end of the name by the date.

Example:

BigDataEmplGeral0908.txt

and

BigDataEmplGeral0909.txt

I'd like Loading all of them like:

BigDataEmplGeral*.txt

If I try to do it from a folder in my Desktop, I get, but I'm trying the same in server:

[http://public/public/BigDataEmplGeral*.txt] and It's giving error.

Someone?

4 Replies

What is the error that you are seeing?

The http protocol does not support wildcards like that. The same applies to the ftp protocol.They also do not support iteration with FileList().

If these are sharepoint files, try to access them from the network folder, rather than via sharepoint.

If they are web files, you will need to know the full file names. For FTP you can run an LS command and get the file list into a local file which you can then read. For http files, it depends on the web site.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Hi, Jonathan.

Tks for the answer.

In fact they are web files and I know the full name, but there is a new file every day.

The full name is BigDataEmplGeral + Date of creation+ .txt

If I understood what you said, I won't use "*" replacing the date and read all files in the web, will I?

If you know what the file name will be, you could do it dynamically something like this

Let vDate = Date(Today(), 'MMDD');

LOAD *

FROM http://public/public/BigDataEmplGeral$(VDate).txt

(txt, ....);

Adapt this to your exact requirements.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein