Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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