topic How to load multiples files with STRANGE filenames? in QlikView

How to load multiples files with STRANGE filenames?

Fri, 05 Aug 2011 05:20:26 GMT

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?

Anonymous — Fri, 05 Aug 2011 07:41:25 GMT

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.

Fri, 05 Aug 2011 08:39:08 GMT

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 !