I am bringing in an excel table and then adding some different attributes to it and writing it out to a geodatabase. I need to create a unique ID when writing it out to the geodatabase. I have brought in the original table and determined what the largest ID number is. I can't figure out though how to add it to the workspace without each row getting the same ID number.
Solved
Create a unique ID
+3Best answer by dustin
It would be similar workflow, but only table 1 would be fed into the StatisticsCalculator. The max value would then be passed via FeatureMerger to table 2 for processing those IDs.
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.
+35- Influencer
So you want the new Unique IDs in the geodatabase to pick up where the excel IDs ended? If so, I would feed the excel features into a StatisticsCalculator, and specify you want to calculate the max value on the Unique ID field. After that, connect the Complete port to a Counter with Count Start parameter set to (id.max)+1 in the Arithmetic Editor.
+3No, excel (table 1) doesn't have the unique ID. The unique ID is coming from another table (table 2). So I find the largest number from table 2 and pass it on to table 1. And then I want it to increment from there.
+35- Influencer
- Best Answer
It would be similar workflow, but only table 1 would be fed into the StatisticsCalculator. The max value would then be passed via FeatureMerger to table 2 for processing those IDs.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.