Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Tags (1)
4 Replies

Re: Problem in Load

What is the error that you are seeing?

MVP
MVP

Re: Problem in Load

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

Re: Problem in Load

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?

MVP
MVP

Re: Problem in Load

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
Community Browser