Hi,
I have a CSV file containing ObjectID
and associated AttachmentNumber
values.
I want to group the ObjectID
s so that the total number of attachments in each group is as close to 1,000 as possible.
How can I achieve this?
Hi,
I have a CSV file containing ObjectID
and associated AttachmentNumber
values.
I want to group the ObjectID
s so that the total number of attachments in each group is as close to 1,000 as possible.
How can I achieve this?
Hi
Hope that helps!
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 !
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.