Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to load multiples files with STRANGE filenames?

Hi,

I have a folder with many files like SALE_AP_2011-08-05.LOG

So, i create a LOAD script and FROM SALE_*.log

the data wont store in the table.

it works if i change the file name to SALE_AP.log

In this case, i get only one file.

I think it's probably some syntax error for the FROM?

1 Solution

Accepted Solutions
adurquety
New Contributor III

How to load multiples files with STRANGE filenames?

hi guy,

I tried an example with 2 log files.

I used the wizard to select one file.

I had this :

Directory;

LOAD *

FROM

[SALE_AP_2011-08-05.LOG]

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

and then I change the "from" with that :

Directory;

LOAD *

FROM

[SALE_AP_*.LOG]

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

and it is working for me. I've got one table  and all the data from my 2 files in the table.

2 Replies
adurquety
New Contributor III

How to load multiples files with STRANGE filenames?

hi guy,

I tried an example with 2 log files.

I used the wizard to select one file.

I had this :

Directory;

LOAD *

FROM

[SALE_AP_2011-08-05.LOG]

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

and then I change the "from" with that :

Directory;

LOAD *

FROM

[SALE_AP_*.LOG]

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

and it is working for me. I've got one table  and all the data from my 2 files in the table.

Not applicable

How to load multiples files with STRANGE filenames?

Hey, thanks !

I went back to reload again, i can also see data coming into QV,

it must be something else...

thanks for the test !

Community Browser