Christmas Riddle

ulrich_schumann

Hi all,

just saw a Christmas riddle and was wondering how to dispay ALL possible cominations of fragments into an Excel list. Enclosed is a short table with 5 positions (POS) and 3 possible fragments per position. If you put all possible cominations in the list, you would finally see somewhere the solution to the riddle.

The expected solution is for

POS1 MER

POS2 RYC

POS3 HR

POS4 IST

POS5 MAS

Any ideas how to create the entire list of all possible combinations (order is already fixed by the position) with an Alteryx workflow?

"MERRYCHRISTMAS" to the Alteryx Community.

Christmas riddle.xlsx

Data Investigation

Accepted answers

This was a neat one, that gave me an excuse to use a "Multi-Output Filter" macro which made this really easy.

The key was using Append Fields to create the list of all combinations.

claje_combinationriddle.yxzp

My quick go from first principles:

Generate a set of rows and then join to input

All combinations.yxmd

All comments

This was a neat one, that gave me an excuse to use a "Multi-Output Filter" macro which made this really easy.

The key was using Append Fields to create the list of all combinations.

claje_combinationriddle.yxzp

My quick go from first principles:

Generate a set of rows and then join to input

All combinations.yxmd

ulrich_schumann

Understanding your macro might cause me some headache :-) But very good learning experience for me. Thanks for sharing!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703