Jump to content

Join Capsules by Matching Capsule Properties

Go to solution Solved by John Brezovec,

Recommended Posts

  • Seeq Team

I have a batch operation characterized by two conditions: The first condition represents the start of the batch and the second condition contains the end of the batch. Each capsule has the batch ID as a capsule property. How can I make a single condition that represents the duration of the batch by joining the start and end conditions?

  • Like 2
Link to comment
Share on other sites

  • Seeq Team
  • Solution

Solution 1 - Simple Join

If the batches are orderly and the end of one batch does not overlap with the start of the next batch, then using the Join logic in the Composite Condition tool is the easiest option.


However, if the end of one batch overlaps with the start of another, then some batches may not be joined. In the screenshot below the third batch on June 6 is not joined.



Solution 2 - Use Formula to join based on matching the batch ID capsule property

By using join in Formula all the batches in this scenario can be joined. In addition the batch ID property is retained in the new capsules.


// 40h is the maximum capsule duration
// true tells Seeq to try to make the biggest capsules if there are multiple start capsules per end capsule
// BatchID is the capsule that is common between the start and end
$startCondition.join($endCondition, 40h, true, 'BatchID')


Content Verified DEC2023

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...