topic Dynamic script for file path in QlikView

Dynamic script for file path

montubhardwaj — Tue, 11 Jan 2011 13:43:12 GMT

Hi Community,

I have little problem creating dynamic path for my application. I want to have a dynamic script which will pull the xyz.log file from each path where the folder is just changing. Please see below for the sample paths.

The values for variables (i.e. India,US,UK etc.) are coming from an spreadsheet. I want to use For loop for pulling into variables for path.

\\qlikviewprod\Apps\India\xyz.log

\\qlikviewprod\Apps\US\xyz.log

\\qlikviewprod\Apps\UK\xyz.log

etc.

Any help is much appreciated.

Dynamic script for file path

hector — Tue, 11 Jan 2011 13:55:28 GMT

Hi,

use peek() or fieldvalue for the loop


Country:
LOAD * INLINE [
 Country
 India
 US
 UK
];

Let n = NoOfRows('Country');
For i = 1 to n
 Let vCountry = fieldvalue('Country',i);
 Files:
 Load
 field
 from '\\qlikviewprod\Apps\$(vCountry)\xyz.log' ; //at least here, load one log just to check how this line is created for your file, then replace the region with the variable
next

Rgds

Dynamic script for file path

montubhardwaj — Tue, 11 Jan 2011 14:06:33 GMT

Perfect Hector. Helped like Hector in "TROY"

Many thanks.