Challenge #247: Pairing Partners

[BS_THE_ANALYST]

Couldn't figure out the algorithm myself. Used the hint with the circle method. Makes complete sense. Just an iterative macro after that!

Spoiler

[michael_apau]

My solution

[Erin]

Well, I'm stuck. I read the hint and watched a video on youtube. I've tried seemingly a 100 versions of my macro and I get close - but no cigar. After too many hours on this one, this is my best shot. I have dupes in my output. So don't call me to organize lunch pairings! 

[lwolfie]

Trying to get through the ones I've been avoiding.

[alexnajm]

Good one @PhilipMannering - I thought I recognized those people 😊

Avoided the iterative macro route, and got all the right pairings just not the weeks. Looking at alternative solutions later on

[Carolyn]

Solved! This should work for any even number of pairings

Spoiler

I'm using the Iteration number and Max RecordID to adjust the RecordIDs in the Join

[JBevan89]

Great Challenge.

That was a lot more challenging in Alteryx to Excel.  In Excel I could get a formula to do really quickly.

I feel like there is a really quick way in Alteryx to do that we are all missing, as with the append you can create 30 records with filtering out the same name combos.  Then somehow you need to half the 30 to 15.  Sean was near to that.

[Matthias_Albert]

Solved with an iterative macro.

Spoiler

Worflow:

Macro: