topic Re: Create Variable Names and Variable Values from Excel File in App Development

Create Variable Names and Variable Values from Excel File

HartbargerL — Fri, 22 Sep 2023 21:20:39 GMT

Hi,

I am trying to create variables using the values in an excel file:

Table:
LOAD
"Variable Name",
"Variable Value",
"Variable Definition"
FROM my_excel_file.xlsx;

let vName = peek([Variable Name], 2);

Trace test: $(vName);

My trace function is returning test:

and the variable is not being created.

anat — Sat, 23 Sep 2023 05:09:19 GMT

Application_Variables:

LOAD VariableName,

VariableDefinition

FROM

Test_27.xlsx

(ooxml, embedded labels, table is Test);

Let vNoOfVariables = FieldValueCount ('VariableName') ;

For v = 0 to $(vNoOfVariables)-1

Let vName = Peek('VariableName',$(v),'Application_Variables');

Let $(vName) = Peek('VariableDefinition',$(v),'Application_Variables');

Next v

Drop Table Application_Variables;

rwunderlich — Sun, 24 Sep 2023 20:45:44 GMT

Good solution. But I'll point out that if there happened to be duplicate VariableNames, this would be a subtle bug,

Let vNoOfVariables = FieldValueCount ('VariableName') ;

Better to use

Let vNoOfVariables = NoOfRows ('Application_Variables') ;

-Rob

HartbargerL — Mon, 25 Sep 2023 12:14:14 GMT

Thanks! That worked for me!