Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

janardhan
Contributor

Loading a list of files

Hi Freinds,

I have some log files like log-20-07-2015.php files for so many different dates in local netwrok location.

I need to load all log files.

Can anyone please help.

Thanks in advance

Janardhan

1 Solution

Accepted Solutions
qumniusomnius
New Contributor III

Re: Loading a list of files

load

*

from \\filepath\log-*.php;

5 Replies
qumniusomnius
New Contributor III

Re: Loading a list of files

load

*

from \\filepath\log-*.php;

janardhan
Contributor

Re: Loading a list of files

Thank u so much its working

janardhan
Contributor

Re: Loading a list of files

Hi Borja,

I have one more requirement , i need to load only last 10 days log files.

Can u pls help me

qumniusomnius
New Contributor III

Re: Loading a list of files

there is probably some nicer way to do this, but something like this:

let load1= '\\filepath\' &  date(num(today())-10,'DD-MM-YYYY')

let load2= '\\filepath\' &  date(num(today())-9,'DD-MM-YYYY')


etc.

then:

load

*

from $(load1);

load

*

from $(load2);

you can probably do the loads in a for loop, dont have time to try it out now,

good luck!

Not applicable

Re: Loading a list of files

Useful Post