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.
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. 

Highlighted
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).

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