I have following things in ini. Let me know how can I read the Path which is there in ini and insert in to qlikview loadscript. This is very urgent requirement. Hope some one can help me out soon.
Hi J M J G S,
Thanks for your help. I need to check whether it works or not. But in the mean time can you please explain how it works. As the source which I have posted is just the sample. So I need to check how it works in the original ini.
Thanks in advance,
mid(@1,6) // What is the use of @ here. It is not given in the tutorial
left(@1,5) = 'Path='; //What is the use of @ here. Also let me know what will be assigned in the 'Path='
Juerg Maier JmiD GmbH Schweiz wrote:<blockquote><pre>LOAD mid(@1,6) as mypath
(txt, codepage is 1252, no labels, delimiter is '\t', msq)
WHERE left(@1,5) = 'Path=';
P.S. you need a slash to close the code section /code in square brackets 
Same thing I have tried in my sample application which is attached to it but it is not showing any values. Please check!
subfield(@1, '=', 1) as Variable,
subfield(@1, '=', 2) as Value
FROM D:\BI\QlikView\Examples\ini-file.ini (txt, codepage is 1252, no labels, delimiter is '\t', msq)
WHERE wildmatch(@1, '*=*') > 0;
Here's an example of reading the value, inserting in a variable and using the variabe in a subsequent LOAD.
LOAD @2 as Path
(txt, codepage is 1252, no labels, delimiter is '=', msq)
WHERE @1 = 'Path'
LET vPath = peek('Path');