Load a variable as a field value from Excel

[dafnis14]

Hi,

Is it possible to achieve the following:

1. Set a variable in the script

2. Define the variable as a value in Excel field

3. Load the field  from Excel and have the variable's value for that field? 

Metric Code	Metric Name
100	aaa
105	bbb
107	$(VParam2) & 'zzz'

Thanks!

[settu_periasamy]

Hi,

Can you explain further with example and  expected output?

[uacg0009]

Hi Dafnis,

So what 's the value of the variable? do you want to make this variable into a input box to make a dynamic variable or something else?

I think there is other way to make this happened, but not adding the variable into the excel.

You can define the variable(for example, vtest) to some value. And in front-end, using if function : when the Metric Code = 107, then output is vtest.

Hope it can help you.

Thanks.

Aiolos

[Anil_Babu_Samineni · Accepted solution]

This should work

If([Metric Code] = 107, $(VParam2) & [Metric Name], [Metric Name])