Variable

[Anil_Babu_Samineni]

Hi,

I have variable file like attachment.

I want to import these variables from one QVW to another QVW.

I want to show same as a.qvw variable to b.qvw variables with Values

- Anil

[Anil_Babu_Samineni]

Manish,

Link is ok. But, When i follow the same way i am getting only one Variable that is first one..

[MK_QSL · Accepted solution]

You have to use something like below loop..

Temp_Variables:

LOAD Name,

     Expression

FROM

YourFileName.xlsx

(ooxml, embedded labels, table is Variables);

For i=0 to NoOfRows('Temp_Variables')-1

  Let vName = Peek('Name', i, 'Temp_Variables'); //Name of Variables

  Let $(vName) = Peek('Expression', i, 'Temp_Variables'); //Definition of Variables

NEXT i;

Let i = null();

Let vName = null();

// Remove temp tables

Drop Table Temp_Variables;

[Anil_Babu_Samineni]

When i load a.qvw file to b.qvw thru Binary it showing only dimensions.

I have one more question, If we are fetching the dimensions from another qvw why Groups(Drill, Cyclic) are not coming.

Can i know the reason??

[MK_QSL]

Sorry bro. no idea