Dynamic script for file path

[montubhardwaj]

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.

[hector · Accepted solution]

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

[montubhardwaj]

Perfect Hector. Helped like Hector in "TROY"

Many thanks.