Evaluate() function on formula in table field during load

[dirk_fischer]

Hi community,

I struggle with the attached load script, which is not working as expected although I tried to base it upon the example in the online help.

For some reason the Evaluate(FORMULA) returns 0 for the first line and Null for all following lines, so it looks like it does not evaluate the content of the field FORMULA as proper formula.

TEST:
Load
Evaluate(FORMULA) As EVALUATED,
*
Inline [FORMULA, FIELD01, FIELD02
'RangeSum(FIELD01, FIELD02)', 1, 2
'RangeMax(FIELD01, FIELD02)', 1, 2
'RangeMin(FIELD01, FIELD02)', 1, 2
FIELD01 * 3, 1, 2
];

Does anybody have an idea, what is wrong in this code? Or is this a limitation of the Evaluate() function?

Best regards,

Dirk

[dirk_fischer]

Marcus,

this is awesome!!!

It does the trick and creates exactly the result, I want to have without looping through the datasets. Great.

Thank you so much for your help. I will remember this Pick function within  a parameterized variable. That's a really cool trick.

Best regards

Dirk