field values assign variable

[#1]

Hi,

i have loaded a table into my script

LOAD VariableName,

     VariableValue,

     VariableType,

     VariableFormat

FROM

(ooxml, embedded labels, table is [Color Settings]);

i Need to create variable with these field names.

can somebody please help me

[#2]

If your Table Name is Tab:

Tab:

LOAD

VariableName,

     VariableValue,

     VariableType,

     VariableFormat

FROM

(ooxml, embedded labels, table is [Color Settings]);

Let VariableName= peek('VariableName',0,'Tab');

Let VariableValue= peek('VariableValue',0,'Tab');

Let VariableType= peek('VariableType',0,'Tab');

Let VariableFormat= peek('VariableFormat',0,'Tab');

Add that in a for loop if you have more than 1 Color.

[amit_saini]

Hi,

Do you mean to create variables by using fields VariableName ,VariableValue and so on....?????

Thanks,
AS

[#4]

Hi Amit saini,

Yes i need to create variables by using fields VariableName ,VariableValue and so on...

[amit_saini]

Hi,

You can do like this (Press CTRL + ALT +V and set the value of variables, they way i did for vV1 ,vV2 and so on)  or follow Eva POLINI suggestion also, both will work:

Thanks,

AS

[#6]

It you run my script, you will have 4 variables : VariableName, VariableValue, VariableType, VariableFormat.

[amit_saini]

Eva,

I know this will also work, I suggested him one more way of assigning values to different variables.

Thanks,
AS

[#8]

Sorry, my bad !! I read to fast... for any reason, I read "do both in the same time...."

[#9]

Hi I created the variable but i am not getting the data.

[amit_saini]

No Problem !

Cheers,

AS