topic Re: Problem in Load in QlikView

Problem in Load

Thu, 10 Sep 2015 23:18:58 GMT

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?

Re: Problem in Load

sunny_talwar — Fri, 11 Sep 2015 09:44:29 GMT

What is the error that you are seeing?

Re: Problem in Load

jonathandienst — Fri, 11 Sep 2015 09:56:34 GMT

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.

Re: Problem in Load

Fri, 11 Sep 2015 14:16:54 GMT

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?

Re: Problem in Load

jonathandienst — Fri, 11 Sep 2015 14:33:49 GMT

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.