Hi FME Experts,
I have a field, I would like to create a new field based on duplication of the records in this field . as the attached image, is there any way to do that?
Thanks in advance
Solved
Calculate the field value based on another field.
+4- Participant
- 19 replies
Best answer by takashi
OK. You can use the Counter with a counter name containing the user name.
e.g.
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.
- 7843 replies
Do you need to get the number of records for each User Name? That is, should you get 3 for A, 1 for B, 6 for D in your example?
+4- Participant
- 19 replies
Do you need to get the number of records for each User Name? That is, should you get 3 for A, 1 for B, 6 for D in your example?
@takashi
No, I want the result to be like the (user_id) field in the screenshot
- 7843 replies
- Best Answer
OK. You can use the Counter with a counter name containing the user name.
e.g.
+4- Participant
- 19 replies
OK. You can use the Counter with a counter name containing the user name.
e.g.
@takashi
Thank you, what about if I want to the output to be (00001,00002,.....,00026), in which the number of digits to be 5.
- 7843 replies
OK. You can use the Counter with a counter name containing the user name.
e.g.
Have a look at the StringFormatter.
+4- Participant
- 19 replies
Have a look at the StringFormatter.
Thank you @takashi ,
Could you please assist me it this?
I am trying to extract the Max value from a field then use it in calculating the value for another field (sequence).
But it gives me the below error
- 7843 replies
Have a look at the StringFormatter.
If you intend to newly create the attribute "PID" in the AttributeManager with such parameters setting, try exposing "PID" with the AttributeExposer beforehand.
However, I think you can do it with the Counter (Count Start: 150266) more easily.
+4- Participant
- 19 replies
If you intend to newly create the attribute "PID" in the AttributeManager with such parameters setting, try exposing "PID" with the AttributeExposer beforehand.
However, I think you can do it with the Counter (Count Start: 150266) more easily.
The counter was the alternative solution but should be a more effective way, which the user no need to but the max value from his end.
should be a way to extract the max value (statisticscalculation) , then take a max value then use it to calculate the new field.