Hi FME Community,
I have a column with number. I want to add a dot to the last three numbers.
the pictures show what I expect as a result:
what I have:
Thanks in advance :)
Page 1 / 1
Devide it by 1000.
AttributeCreator, AttributeA = @Evaluate(@Value(AttributeA)/1000)
oh that was very simple what I was thinking.
thanks alot @nielsgerrits
@nielsgerrits I have a problem with process execution. I actually have this value:
then I deleted points by using StringReplacer (up to here works very well)
and divided my value by 1000 by using AttributeCreator. Nevertheless, I get a warning and my column is not filled with anything. (I also converted my value to int64 but it didn't work either) (all lines also have values).
as a warning I get:
AttributeCreator_2: Failed to evaluate expression '@real64(<null>/1000)'. Result is set to null
@nielsgerrits I have a problem with process execution. I actually have this value:
then I deleted points by using StringReplacer (up to here works very well)
and divided my value by 1000 by using AttributeCreator. Nevertheless, I get a warning and my column is not filled with anything. (I also converted my value to int64 but it didn't work either) (all lines also have values).
as a warning I get:
AttributeCreator_2: Failed to evaluate expression '@real64(<null>/1000)'. Result is set to null
This means that the AttributeCreator finds a row with a null value, and null/1000 is invalid. Put a Tester between the StringReplacer and AttributeCreator_2, test Attribute has a value.
@nielsgerrits I have a problem with process execution. I actually have this value:
then I deleted points by using StringReplacer (up to here works very well)
and divided my value by 1000 by using AttributeCreator. Nevertheless, I get a warning and my column is not filled with anything. (I also converted my value to int64 but it didn't work either) (all lines also have values).
as a warning I get:
AttributeCreator_2: Failed to evaluate expression '@real64(<null>/1000)'. Result is set to null
@nielsgerrits I have already filtered all null, missing and empty attributes beforehand.
I watch my values after StringReplacer and after AttributeCreator_2 by Inspector
Inspector _3:
inspector_2:
inspector_3:
@nielsgerrits I have a problem with process execution. I actually have this value:
then I deleted points by using StringReplacer (up to here works very well)
and divided my value by 1000 by using AttributeCreator. Nevertheless, I get a warning and my column is not filled with anything. (I also converted my value to int64 but it didn't work either) (all lines also have values).
as a warning I get:
AttributeCreator_2: Failed to evaluate expression '@real64(<null>/1000)'. Result is set to null
Is it possible that there are records that just have .... entry so are not null at the stage of your tester but are null after the string replacer?
@nielsgerrits I have a problem with process execution. I actually have this value:
then I deleted points by using StringReplacer (up to here works very well)
and divided my value by 1000 by using AttributeCreator. Nevertheless, I get a warning and my column is not filled with anything. (I also converted my value to int64 but it didn't work either) (all lines also have values).
as a warning I get:
AttributeCreator_2: Failed to evaluate expression '@real64(<null>/1000)'. Result is set to null
Then your formula is wrong. It needs to be
@Evaluate(@Value(col11)/1000)
@nielsgerrits I have a problem with process execution. I actually have this value:
then I deleted points by using StringReplacer (up to here works very well)
and divided my value by 1000 by using AttributeCreator. Nevertheless, I get a warning and my column is not filled with anything. (I also converted my value to int64 but it didn't work either) (all lines also have values).
as a warning I get:
AttributeCreator_2: Failed to evaluate expression '@real64(<null>/1000)'. Result is set to null
@nielsgerrits perfect. Thank you very much 