Evaluate function within a field name

hico-mah — Thu, 03 Aug 2017 14:23:56 GMT

Hi everybody,

I have to get a value from an existing field in the table, based on a function.

As an example:

test:

LOAD

SomeValue

,[Value_$(floor(SomeValue/3) + 1)] AS DependentValue;

LOAD

IterNo() AS SomeValue

,'a' AS Value_1

,'b' AS Value_2

,'c' AS Value_3

AUTOGENERATE 1

while IterNo() < 9;

the lower load Statement will create a table with 8 rows and 4 fields.. the upper Load Statement should now select one of these field values, depending on the first field.

the expecte result would be

test:

SomeValue | DependentValue

1 | a

2 | a

3 | b

4 | b

5 | b

6 | c

7 | c

8 | c

But I only get an Fielde "Value_" not found error, obviously the function is not evaluated correctly.

Thanks for any help

Michael

topic Evaluate function within a field name in App Development

Evaluate function within a field name