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
SOLVED

Dynamically Select Fields based on results of DropDown Selection

Asteroid

Hi, struggling with a challenge.

 

I have a table with 16 fields.

 

e.g. 

 

Fund1, Fund2, Fund3, Fund4, etc.

 

I have a drop down with 

Fund1

Fund2

Fund3

Fund4

 

I'd like my dropdown selection to dynamically select the relevant columns. Does anyone have a solution to this?

 

Help much appreciated. 

Alteryx
Alteryx

I think you'd want to use a list box rather than a drop down.

 

The list box will allow you to have a check box per column, rather than the single option the drop down allows.

 

If you set the list box to accept the field list from your input tool/stream this will load those fields.

 

Like the attached (if you rename to .yxwz).

Highlighted
Asteroid

Thanks. The List Box to MultiSelect does work. I guess I can comment "Please only select one'. 

 

Was thinking as it's a one - to - one relationship - So when I pick fund 1, i only need the fund 1 column back. 

 

 

Alteryx
Alteryx

Ah sorry, I misunderstood.

 

You can connect the drop down in the same way as the list box if you want the user to only select one.

 

I would never rely on the user to only select one

You can do this by feeding the Question output into a Dynamic Select and then using a formula to choose which columns to keep.

clipboard_image_0.png

 

Quick sample based on @JoeS attached

 

One slight warning - remember to tick:

clipboard_image_0.png

as the field output changes...

Asteroid

Think i worked it out - [Name]=[#1]

 

 

 

Asteroid

@jdunkerley79 @JoeS 

New issue, is that as the fields are being dynamically selected in the dropdown of the app. A lot of my downstream tools aren't functioning now, especially summarise tools. 

 

What is the best way to cope with this changing upstream field situation?

 

I can share a sample workflow or screenshots if that would help more?

Alteryx
Alteryx

Hi @CiaranA 

 

Yeah, it'd be best to share your workflow.

 

I'd guess that you may need to change the shape of your data using the transpose tool before a summarize and then a cross tab after.

 

But definitely best if you can upload your example

Asteroid

Would this be better as a chained app?

 

I've attached a sample which aims to show that by dynamically picking a fund, your downstream tools then reference that fund's particular data, pivot it up and summarise in a table. 

Labels