topic Re: How to give a relative path while loading multiple log files in QlikView

How to give a relative path while loading multiple log files

Mon, 17 Oct 2016 10:13:14 GMT

Hi all

I am loading multiple log files in a folder using ' * '

but i am unable to load all the log files using relative path

I have given the relative path as below but I am unable to load the files

Let vPath='..\IISLogs';

FROM

[($vPath)\IISLogs\DEV\a_*.log]

(txt, codepage is 1252, explicit labels, comment is #, delimiter is spaces);

Thank you

Re: How to give a relative path while loading multiple log files

sunny_talwar — Mon, 17 Oct 2016 10:17:34 GMT

Which are the ones which don't load? Do you share there name? Alternatively, you can load using Loops in the Script

Re: How to give a relative path while loading multiple log files

Mon, 17 Oct 2016 10:20:21 GMT

I am unable to load any files.

I am getting the error as system can not find the path specified..

Re: How to give a relative path while loading multiple log files

sunny_talwar — Mon, 17 Oct 2016 10:22:14 GMT

You seem to be repeating IISLogs folder twice, once in your variable and once again in path. Do you have two folder IISLogs? Or is that what the issue might be?

Re: How to give a relative path while loading multiple log files

sunny_talwar — Mon, 17 Oct 2016 10:23:17 GMT

May be you need this

Let vPath='..\IISLogs';

FROM

[($vPath)\DEV\a_*.log]

(txt, codepage is 1252, explicit labels, comment is #, delimiter is spaces);

Re: How to give a relative path while loading multiple log files

Mon, 17 Oct 2016 10:27:44 GMT

Hi sunny

No, I don't have two IISLogs Folder

Now, I have removed the IISLogs in the from but, I couldnt load the files..

Re: How to give a relative path while loading multiple log files

sunny_talwar — Mon, 17 Oct 2016 10:30:23 GMT

Unless you share more details, I think it would be difficult to know what might not be working here.