Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #154: Permute the Data

estherb47
15 - Aurora
15 - Aurora

Excellent, @MarqueeCrew ! Where I'm struggling though is how can you make it handle more than two toggles (on/off, e.g.)  IntToBin is wonderful for 2 choices, but how can we make this work for 3, 4, 5 different answers for each option?

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@estherb47 ,

 

Good point.  When I created this, I knew that I could handle the permutation calculation quickly enough.  I didn't think through how to create the states so fast.  I suppose that I'd have to do something like the append fields trick or multi-row to handle the appropriate state answers.

 

Congrats again on staying ahead of me in the solutions race.  With zealous community members like @Thableaus and @DavidP leading the group, it's nice to see you rounding out the group.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
cplewis90
13 - Pulsar
13 - Pulsar

This is definitely a brute force method as I am still working on the macro to be more dynamic. Definitely curious to see if anyone can be dynamic without using a macro!

Spoiler
Challenge 154.PNG
danilang
19 - Altair
19 - Altair

Hi @estherb47 

 

Here's my second pass at it with a custom iterative macro that does IntToBaseN(). 

 

Results v2.png

 

 

Spoiler
The results are returned as a alpha string (AAA,AAB,etc) to get more than 10 toggle positions,  which is then joined back to the list of toggles.  The InttoBaseN just applies math to do the conversion.

MainIntToBaseN Macro 

Cheers 

 

Dan

karp
6 - Meteoroid

@MarqueeCrew, I really like the simplicity of your solution in the sense that it's a clean way to do the math without brute-forcing it with nested append tools like I did.  I'm curious to know why you wrote your formula the way you did in Formula Tool (50).  Couldn't you just leave off the "-1"?  It looks like you account for it in your Generate Rows (40) by having your initialization expression at "0".  I'm wondering if there's a reason you did it this way.  Also, the Concat Options is clever.  I think if I had thought of that from the beginning of my solution, things would have turned out differently - I seem to remember banging my head against the wall yesterday as I have all the results themselves concatenated as "Off,On,Off" (etc.), but was stumped at to how to break out the actual tool labels.  Definitely one of those "so obvious, why didn't I think of that".  Good experience to implement in future workflows, thanks!

lminors
9 - Comet

Don't need maths - leave it up to chance!

 

Spoiler
Generate shed loads of rows and assign either 1 or 0 (On or Off) at random. Concatenate these and take all unique options. Voila!

Capture.JPG
ponraj
13 - Pulsar

Here is my workflow for this challenge!

 

Spoiler
Permute the Data.PNG
pasccout
8 - Asteroid

Wow... nice challenge this week... Had to really think about it...

 

The solution is dynamic... you can change either option 1 or option 2 input and it will assign them correctly...

 

The final results works... not the same order as yours though...

RichoBsJ
11 - Bolide

Hi! Here my solution :)

catarina_pimpao
8 - Asteroid
Spoiler
AWC_154.PNG