This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Gather all 9 clues to complete the final Weekly Challenge on Dec 16!
Hi, struggling with a challenge.
I have a table with 16 fields.
Fund1, Fund2, Fund3, Fund4, etc.
I have a drop down with
I'd like my dropdown selection to dynamically select the relevant columns. Does anyone have a solution to this?
Help much appreciated.
Go to Solution.
Go to Solution.
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).
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.
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.
Quick sample based on @JoeS attached
One slight warning - remember to tick:
as the field output changes...
Think i worked it out - [Name]=[#1]
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?
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
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.