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: 
janardhan
Creator
Creator

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
Contributor III
Contributor III

load

*

from \\filepath\log-*.php;

View solution in original post

5 Replies
qumniusomnius
Contributor III
Contributor III

load

*

from \\filepath\log-*.php;

janardhan
Creator
Creator
Author

Thank u so much its working

janardhan
Creator
Creator
Author

Hi Borja,

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

Can u pls help me

qumniusomnius
Contributor III
Contributor III

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

Useful Post