topic Re: setting variables in binary load in QlikView

setting variables in binary load

Fri, 07 Mar 2014 22:18:23 GMT

HI guys,

I am doing binary load of one QVW file into another one.

I need to set values of some variables like path of my QVD files in the first QVW file before Binary load statement executes in the second QVW file.

Any suggestions on how to do that?

Regards,

Saurabh

Re: setting variables in binary load

Fri, 07 Mar 2014 22:29:42 GMT

Hey Ramya,

If you have publisher you can set up triggers to reload files sequentially.

Like Reload File 1 > Trigger (on successful completion of File1) > Reload File2

here File2 is a binary load of File1.

So File2 wont be reloaded until File1 is complete.

Edit: Also this can be done if you just have server.

Thanks

Re: setting variables in binary load

Sat, 08 Mar 2014 00:59:41 GMT

Hi,

Binary Load must be the first statement of script, so nothing can be set or changed before binary load

Binary Load will get any data loaded as is from your binary file

then you can set, load, drop etc. any further ETL after binary load

What would you like to achive if you can elaborate it is better to help ...

Best

Re: setting variables in binary load

Sat, 08 Mar 2014 03:13:30 GMT

Hi Ersen,

The path of my QVD files keeps changing so I need to mention the path of QVD files before binary load.

Saurabh

Re: setting variables in binary load

Sat, 08 Mar 2014 03:13:54 GMT

i just have desktop version.

Re: setting variables in binary load

Sat, 08 Mar 2014 03:54:07 GMT

You have two files right.

File1 set your variables. Reload it.
File2 which has binary load. Reload it.

Is there something that I am missing. Do you want to copy those variables as well from File1 to File2?

Can you please elaborate a little on what the objective is?

Re: setting variables in binary load

Sat, 08 Mar 2014 04:42:50 GMT

Hi,

Binary load statement will not trigger reloading QVDs inside binary qvw.

If you are reloading QVDs after binary load statement you can set paths

after the binary load in the script.

Ersen

Re: setting variables in binary load

SunilChauhan — Sat, 08 Mar 2014 05:19:22 GMT

In first QVw file create variable like below

set var=10;

set var1=20;

Load $(var) as varField,

$(var1) as varField1

autogenerate 1;

and then use this qvw into another Qvw .

then you will have varField in second Qvw.

see the attched files

Hope this helps

Re: setting variables in binary load

maxgro — Sat, 08 Mar 2014 07:51:31 GMT

to move variable from first qvw to second qvw (the one with binary load) you can look at these posts

Binary Load - Variables

Binary load and passing Variable(s) with it

Re: setting variables in binary load

Sun, 09 Mar 2014 05:02:22 GMT

Hi Ajay,

Thanks for your reply.

I need to specify the path of my QVD files in my first QVW. This path can change dynamically so I can not hardcode it.

I need to access these variables from outside of QVW and set the values and then need to load the first QVW.

Do you think i need to use automation for it?

Re: setting variables in binary load

Colin-Albert — Sun, 09 Mar 2014 08:40:32 GMT

You could use an include file to hold the variable definitions and then call the include file in both QVWS.

Importing text files containing scripts?

Re: setting variables in binary load

Mon, 10 Mar 2014 17:39:28 GMT

Hi Saurabh,

You can create your binary load statement in text file (.txt or .qvs) file and include in your main application.

/********* Main Application *******/

$(Must_Include=binary.txt); // or include

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

// rest of script ...

Binary load statement script could be generated (manually or automatically) something like below:

/********* binary.txt *******/

BINARY numbers_2.qvw;

It will have one statement, here source numbers_2.qvw can be changed manually or automatically. I think you will generate this binary.txt through some automation.

Does this help ?

Ersen