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

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
Anonymous
Not applicable
Author

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.

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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
Author

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 !