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