+3Hello,
I have an excel files with values in it. I read the excel file, want to use the value from column E (value is 45), use it in a math formular and calculate a new value. At the end the result should be written in to a Feature class in a FGDB. The transformer I want to use is expression value. But the calculation doesn’t work.
Has anyone an idea?
Thank you!
Teresa
Best answer by jobvdnoort
Hi,
I use this expression:
Th result is this:
The text of the expression instead of the calculated value.
Do I have change the datatype of the input field?
Thank you!
Teresa
Hee you have to make sure to use @evaluate around the full expression:
+11Hi Teresa,
I use a featurereader for this, where in this example I read this Excel file with some numbers:
In the inspector it looks like this: (no headers)
In an attribute creator you can also do some mathmatical formulas
And the result:
Edit:
You can also do the same thing with the expression evaluator:
Result:
Is this what you are looking for?
You can write the result to a GDB using the featurewriter :)
+3Hi,
I use this expression:
Th result is this:
The text of the expression instead of the calculated value.
Do I have change the datatype of the input field?
Thank you!
Teresa
+11Hi,
I use this expression:
Th result is this:
The text of the expression instead of the calculated value.
Do I have change the datatype of the input field?
Thank you!
Teresa
Hee you have to make sure to use @evaluate around the full expression:
