community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Scenario Combinations

Highlighted
Meteoroid

I have been stuck on this for a day now, it seems so simple but I am struggling to find the solution.  I am looking to create all possible scenarios based upon two options. 

 

Example 1

My Data

Option 1Option 2
AppleOn
OrangeOff

 

Desired Outcome

ScenarioOption 1Option 2
1AppleOn
1OrangeOn
2AppleOn
2OrangeOff
3AppleOff
3OrangeOn
4AppleOff
4OrangeOff

 

Example 2

My Data

Option 1Option 2
AppleOn
OrangeOff
Cherry 

 

Desired Outcome

ScenarioOption 1Option 2
1AppleOn
1OrangeOn
1CherryOn
2AppleOn
2OrangeOn
2CherryOff
3AppleOn
3OrangeOff
3CherryOn
4AppleOn
4OrangeOff
4CherryOff
5AppleOff
5OrangeOn
5CherryOn
6AppleOff
6OrangeOn
6CherryOff
7AppleOff
7OrangeOff
7CherryOn
8AppleOff
8OrangeOff
8CherryOff
Alteryx
Alteryx

@iellingsonbg  the append fields tool would be a tool of interest in this use case. let me know if you run into any issues.

Meteoroid

@DiganP wrote:

@iellingsonbg  the append fields tool would be a tool of interest in this use case. let me know if you run into any issues.


Yes I have tried the append fields as this seems the natural solution but I have been unable to find the correct pattern to get it to produce the desired result.

Alteryx
Alteryx

@iellingsonbg I attached a sample workflows, hopefully that helps. 

Meteoroid

This works perfectly for the 2 fruit.  However when I introduce the 3rd fruit my scenarios do not line up properly (even when modifying to include 3 options per scenario rather than just 2).

Alteryx Certified Partner
Alteryx Certified Partner

@iellingsonbg,

 

I solved this for a dynamic set of option 1 items and a fixed set of On/Off values.  I'm happy to share my solution with you if you private message me.  I'd like to suggest this as a weekly challenge to Alteryx @JoeM .

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels