Coffee Catch ups

Hi,

Trying to automate a coffee catch up process for the team on a weekly basis without repeating the combinations in

the past. Managed to work out all the combinations, but I'm struggling to produce the new combinations that consist of the everyone on a weekly basis.

Any help would be greatly appreciated!

Thanks,

Woon

Datasets

Data Investigation

Accepted answers

Greg_Murray

This was a doozy.

Here you are. This workflow could definitely use some cleaning up and maybe a visit from the iterative macro fairy, but it meets your requirement.

brief overview:

1. find unique participant groupings (of 2 participants)

2. find unique weekly groupings (4 groups of 2 participants)

3. append weekly grouping together, filtering out repeated groupings until all 7 weeks are filled

Hope that helps.

Thanks,

Greg

coffee chat.yxzp

philipmannering

Hey @WoonL

Please see attached my solution. It's a bit of a brute force approach, but it should work for any even number of names that you feed it.

Let me know if it works.

Thanks,

Phil

Edit: Adding the 2020.2 yxmd and yxmc files.

Coffee Chat.yxzp

Coffee Chat.yxmd

Coffee Chat Macro.yxmc

philipmannering

HI @WoonL ,

Think I found a better solution. Should be able to handle a lot more participants. See attached.

Thx,

Phil

Coffee Catch-up Pairings.yxmd

All comments

Greg_Murray

Hi @WoonL ,

Do you have an example or sample of your workflow. If you provide data, it should make it easier to understand what you are trying to accomplish.

Greg

WoonL

Please see sample attached. The objective is to generate catch ups with all 8 people included on a weekly basis and going forward the combinations won't be repeated.

Coffee Data.xlsx

Greg_Murray

This was a doozy.

Here you are. This workflow could definitely use some cleaning up and maybe a visit from the iterative macro fairy, but it meets your requirement.

brief overview:

1. find unique participant groupings (of 2 participants)

2. find unique weekly groupings (4 groups of 2 participants)

3. append weekly grouping together, filtering out repeated groupings until all 7 weeks are filled

Hope that helps.

Thanks,

Greg

coffee chat.yxzp

WoonL

Thanks Greg & Philip! Both Solutions worked for the proposed solution.

(My bad for not mentioning this) However, I have 40+ participants in the actual data, which doesn't work too well with the proposed solutions.

I partially solved it by creating my first iterative macro as per attached. It outputs all the first unique pairs and remove past pairs. Problem - because it outputs the first unique pairs, it might miss one or two pairs from the actual list after a few loops.

Coffee Run - Alteryx Test.yxzp

udles5666

I had a similar problem like this & this thread helped. 🙂

philipmannering

HI @WoonL ,

Think I found a better solution. Should be able to handle a lot more participants. See attached.

Thx,

Phil

Coffee Catch-up Pairings.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335