setting variables in binary load

[#1]

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

[#2]

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

AJ

[#3]

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

[#4]

Hi Ersen,

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

Saurabh

[#5]

i just have desktop version.

[#6]

You have two files right.

1. File1 set your variables. Reload it.
2. 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?

[#7]

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

[SunilChauhan]

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

[maxgro]

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

[#10]

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?