Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create a table of all possible values

aselameab
5 - Atom

On the interface on the app I'm developing, a user selects:

 

Field namePossible Values
Customer NameOnly one selection allowed from a long list of possible values
ProductMulti selection, 1+
Day of the weekOnly two options, Weekday or Weekend

 

An example of a selection might be:

 

Customer B
Toys; Cars; Trucks; Boats; Planes
Weekday
Price

 

Based on a user's selections, I want a table generated that provides the universe of possble options. So, in this example (with the above selections), I want this table to be generated:

Customer NameProductDay of WeekPrice
Customer BToyWeekday 
Customer BCarsWeekday 
Customer BTrucksWeekday 
Customer BBoatsWeekday 
Customer BPlanesWeekday 
2 REPLIES 2
Kanderson
10 - Fireball

I have attached a small example I hope you find useful. I combined the multi select list box with a filter tool to limit the product selection, and used the append tool to produce all of the possible outcomes. If you have any questions let me know.

 

Good luck

aselameab
5 - Atom

Perfect!! Thank you!!

Labels
Top Solution Authors