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

[amit_saini]

Could you please share you application.

Thanks,

AS

[#3]

I can not find the attachment symbol to attach Application

[amit_saini]

Hi ,

See below at the top there is a option right top side "Use Advanced editor"  click this and you will be having attachment option.

Thanks,
AS

[#5]

have you got a table "Tab" with values in?

[#6]

Hi i attached the value in the table please give me solution how can i get those values using variable

[#7]

I add the let statement, it's just to be able to set the variable in the script.

For the interface: =If(Count(VariableName)=1,VariableName)

[#8]

That is fine but if i use the variable in charts & text boxes the data is not coming

[#9]

What's about that?

[#10]

Hi, Need help

Try something like this:

test:

LOAD *,RowNo() as ID

Resident [Color Settings];

DROP Table [Color Settings];

tempRowsNum:

First 1 LOAD ID as RowsNum

Resident test

Order By ID desc;

LET vRowsNum = Peek('RowsNum',0,'tempRowsNum');

DROP Table tempRowsNum;

FOR vRow = 1 to $(vRowsNum)

     LET vName = Peek('VariableName',$(vRow),'test');

     LET vExpr = Peek('VariableValue',$(vRow),'test');

     SET $(vName) = $(vExpr);

NEXT vRow;

[amit_saini]

Hi ,

I'm not sure what you are trying to achieve here , you already having filed which you can use in your calculation. I 'm not sure if this is possible which you are trying to do by using variables here.

Thanks,

AS