Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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