Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
sunny_talwar

What is the error that you are seeing?

jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

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?

jonathandienst
Partner - Champion III
Partner - Champion III

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