topic Re: read variable into realodscript from text file in QlikView

read variable into realodscript from text file

Mon, 13 Sep 2010 15:48:22 GMT

Hello,

Someone know how can I read into the reload script value from text file.

for example, I have a text file which is including the number 91.

I want to run the reload script so it will take the number 91 from the text file (saving it as variable) and then will execute

for i=1 to 91

How can I do it?

Thanks,

Nimrod

read variable into realodscript from text file

Mon, 13 Sep 2010 18:38:34 GMT

I think in case of variable declaration u have to make it from qv script or from variable overview tab only.......

Regards,

Dushyant

read variable into realodscript from text file

Tue, 14 Sep 2010 08:22:40 GMT

it's exactly what I want... the question is how to do it.

read variable into realodscript from text file

Tue, 14 Sep 2010 11:39:04 GMT

Hi Nimrod,

You can read this from the txt file.

LOAD DField

FROM Data.txt;

LET vDField = FieldValue('DField', 1);

FOR I = 1 TO $(vDField) STEP 1

-Yoursourcode

Hope, it will give you idea to read data from any external sources.

Regards,

Raj Kishor

read variable into realodscript from text file

Wed, 22 Sep 2010 10:36:32 GMT

Thx for your response.

how do I have to save this field into the txt file?

read variable into realodscript from text file

Sun, 26 Sep 2010 15:22:32 GMT

I will appreciate your response. thx.

read variable into realodscript from text file

Miguel_Angel_Baeyens — Sun, 26 Sep 2010 17:51:41 GMT

Hello,

If you mean how to save the value you are going to read following Raj's code posted above, you can do that in a QVD file or TXT file, just make sure it has the field name you are going to use in the script, in this case "DField", creating a textfile with the following

DField91

Hope that helps.

read variable into realodscript from text file

Mon, 27 Sep 2010 05:23:52 GMT

Hi,

If I am well understanding you question then you need to read the variable from txt file. So in this case you need to create a txt file and define you varialbes there same as QlikView syntax. Then you can include that text file in you script from Edit->Include File. For exanple let's write a variable in txt file called vLoopLimit which should be written as under:-

Let vLoolLimit = 91;

So when you include this txt file into ur script you can easily access this variable.

Re: read variable into realodscript from text file

bingli881 — Wed, 10 Apr 2019 21:27:15 GMT

How do I use this variable?