Am I taking you too literally or will this do? :)
Suggested approach. Generating the unique IDs at the bottom - and merging them with the original features with a Featuremerger afterwards. Might be a start if I understand correctly?
Am I taking you too literally or will this do? :)
Thanks, this is close to what i was after. The output was something like EXM-10001 based on the original source data which would be EXM12345.
Thanks
Suggested approach. Generating the unique IDs at the bottom - and merging them with the original features with a Featuremerger afterwards. Might be a start if I understand correctly?
I am struggling to understand where the output would be: EXM-10001 if based on EXM12345, where this change occurs?
This is a output that is required if it makes sense.
Current Data i have is ID:
I want it to convert it to another column based on the source data. The counter does not work as it seems to only doing it based on the row and gives it a unique identifer. Also trying to work out how it can give it a identifer with EXM-XXXXXX after it.
ID (Source Data) Output based on ID
EXM12345
EXM-100001
EXM12346
EXM-100002
EXM12347
EXM-100003
EXM12345
EXM-100001
I am struggling to understand where the output would be: EXM-10001 if based on EXM12345, where this change occurs?
The "newID" is brought back to the original data in the Feature Merger. I think @sigtill's solution will work nicely. If you want to have the count for the new ID to start at 100,000 you just set up the Counter ot being then. The DuplicateFilter is important here as it ensures you only generate one ID for each unique original ID.
This is a output that is required if it makes sense.
Current Data i have is ID:
I want it to convert it to another column based on the source data. The counter does not work as it seems to only doing it based on the row and gives it a unique identifer. Also trying to work out how it can give it a identifer with EXM-XXXXXX after it.
ID (Source Data) Output based on ID
EXM12345
EXM-100001
EXM12346
EXM-100002
EXM12347
EXM-100003
EXM12345
EXM-100001
Then I think the solution @sigtill described is the one to go for, just maybe with a Sorter between the DuplicateFilter and the Counter.
The key is that you use the lower part of @sigtill's workspace to create your translation table, where I understand that you want your output to be EXM- followed by 100001 and upwards in increments of one, connected to your source IDs in order.
The upper part of the workspace sends all the features, duplicates or not, straight through and then the FeatureMerger gives them their new ID based on the translation table.
Assuming that the number can be assumed based on the existing value minus 12344 + 10,000, this should work. Identify the number in the expression, calculate the new numerical value, replace the existing numbers with a hyphen plus new number
Assuming that the number can be assumed based on the existing value minus 12344 + 10,000, this should work. Identify the number in the expression, calculate the new numerical value, replace the existing numbers with a hyphen plus new number
After bit of playing around, this is what i was after. Really appreciate your help.
