topic Re: Text file into variable in QlikView

Text file into variable

Thu, 25 Apr 2013 07:58:14 GMT

Good morning all !

Someone know how can I insert the content of a text file into a variable in the script ?

Thanks a lot

amars — Thu, 25 Apr 2013 08:05:31 GMT

Hi Victor,

It is same as declaring a Variable inside your script.

Write

Let vTest = 'Test Load';

inside your text file.

Now Gp to your Dashboard -> Edit Script -> Insert -> Include Statement -> Then select the Text File just created.

Load the Dashboard and see the Variable is created inside your dashboard.

Thanks.

Amar

Thu, 25 Apr 2013 08:15:43 GMT

Hi !

I does not work, I've got an error on the line :

tab2 = $(Include=c:\users\vboudart\desktop\modeli\appli\textfile.txt);

The content of my text file is like this : France,Belgium,USA, .....................

Thu, 25 Apr 2013 08:21:39 GMT

Ok, I have add ' like this ;

LET tab = '$(Include=c:\users\vboudart\desktop\modeli\appli\textfile.txt)';

and it's work.

Thanks

Victor