Creating dynamic interface dropdown tool of unique values coming from a single column

[BretCarr]

Hello all,

I am attempting to make an app interface that takes a macros incoming data stream and allows the user:

     1. uses drop down interface tool

     2. pulls the values of a single field/column

     3. summarizes values into single unique values for drop down tool

     4. presents sorted alphabetically

     5. selected value then updates a filter on the input data to pass through only selected value.

Here is what is the basic outline w/o complex interface tools so those with imagination can picture it:

Input Tool (dataType values are ones needed to feed drop down on macro interface):

Macro workflow:

[tomas-matzner]

Hey,

If I've understood correctly, a crosstab tool should give you what you need (see attached configuration to convert the dataType column into field names).

[BretCarr · Accepted solution]

I actually found exactly what I was looking for in terms of a guide in the Alteryx Interactive Lessons. I really was looking to avoid this since I'm sure it'll be a blast trying to get it to work on Server in the Gallery.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120 

[apathetichell]

There was an inquiry about this over the weekend - and I had merged your request and that one in my head - sorry about that - that one was also a chained app.