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 :)
Solved
Add a dot to the last three numbers
+8- Contributor
- 44 replies
Best answer by 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
Then your formula is wrong. It needs to be
@Evaluate(@Value(col11)/1000)
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+60- 2938 replies
Devide it by 1000.
AttributeCreator, AttributeA = @Evaluate(@Value(AttributeA)/1000)
+8- Contributor
- 44 replies
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
+60- 2938 replies
@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.
+8- Contributor
- 44 replies
@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:
+44- Influencer
- 3427 replies
@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?
+60- 2938 replies
- Best Answer
@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)
+8- Contributor
- 44 replies
@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 :)