Load variable from text file

[gerhardl]

Hi there,

If I have a text file named "vPQLow.txt" that contains only a single value (e.g. "54"), how can I get this value and use the 54 as a variable in my Load script?

What I am doing is working from a Powershell script which allows a user to input a campaign number, and this will then create a file with that number in it - I then need to use this number as a variable in QLikView.

[#2]

Hi Gerhard,

Hope the below script helps you.

Variable_Table:

LOAD @1

FROM

Variable_Txt.txt

(txt, codepage is 1252, explicit labels, delimiter is '\t', msq);

LET X=NUM(Peek('@1',0,'Variable_Table'));

[gerhardl]

Thanks Ajay,

I actually just figured out another way to do it, which I think works a bith better. In PowerShell i create the text file to not just right "54", but rather to write "LET vPQLow = 54;"

And then I do this in my QV Script:

$(Include=C:\Path\vPQLow.txt);

[#4]

Thanks Gerhard.

That seems to be much easy way than what i posted

Keep sharing the new findings.

Regards,

Achiever