Hi,
I have a CSV file containing ObjectID and associated AttachmentNumber values.
I want to group the ObjectIDs so that the total number of attachments in each group is as close to 1,000 as possible.
How can I achieve this?
Question
Grouping ObjectIDs by Attachment Count Closest to 1,000
+9- Supporter
+43- Influencer
Hi
Hope that helps!
At your rest service ^B
+28- Influencer
Assuming the following dataset :
One way to do that could be the following
AttachementSum conditional value :
GroupID conditional value :
This method will create groups based on the attachmentSum. Each time the attachmentSum exceeds 1000, the groupID is incremented and the attachmentSum is reset.
It’s a bit tricky, and workbench will give alerts about non-existing attributes, but it will work :
You can then use the groupID attribute to create lists of obectIDs, concatenate, etc…
Hope that helps !
Draw it, map it, shape it, fix it, share it, change it, send, translate it 🎵
It’s a bit tricky, and workbench will give alerts about non-existing attributes, but it will work :
Tips: In a similar case, I would expose the new attribute names with AttributeExposer beforehand, in order to avoid the alerts.
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?