community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

List box tool to be dynamic to select values with in a field

Hi Community,

 

How to give the option in user interface to select the values from a field using list box tool which will be dynamic.

 

For example, I have an app with file browse, after browsing for the file, I get field tagging option to tag fields Field1, Field2, Field3 then I should get the list box option to choose the list of values I want to take in the further calculations like Field3 has values a1,a2,a3,a4,a5 in this I would like to select a1,a3,a5 using list box and if in next run I have new values(a7,a8) in my Field3 those should reflect in the list box selection.

 

Thanks

Highlighted
Magnetar
Magnetar

Hi @PrasadReddyPamula 

 

You can have the List Box tool populate with fields from a connected tool! The key is, the fields you want to be listed must be the column headers, not in rows. Easiest way to do this is to crosstab that field into column headings

 

image.pngimage.png

 

 

You'll wind up with a check list that lists all of the options contained in that field. When they change, the list changes.

image.pngimage.pngimage.png

 

Let me know if this works.

 

Cheers!

Esther

Alteryx
Alteryx

Hi @PrasadReddyPamula 

 

I think you may need to investigate chained apps in order to update the list for the second select based upon the data.

 

There is a great article here

Meteor

Hi @Joes,

 

Can you please proivde a sample workflow to make the list box more dynamic to select from the user selected field.

 

Thanks,

Prasad

Magnetar
Magnetar

Hi @RAMN / @PrasadReddyPamula 

 

Attached is a very basic example of a chained app that uses the results of one app to drive the options in the next one.

 

In the Interface Window, you need to configure app 1 to load up app 2 when it runs successfully. You also need app 2 to use an external file to populate the list box (starting with another input built by the first app doesn't update properly).

 

Hope this helps!!

 

Cheers,

Esther

Meteor

Hi @EstherB47,

 

Thanks for the example. I created my own chained app based on the example.

 

 

Thank you..

RAMN

Labels