Dynamically Select Fields based on results of DropDown Selection

[CiaranA]

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. 

[JoeS]

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

[CiaranA]

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. 

[JoeS]

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 😉

[jdunkerley79 · Accepted solution]

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

[CiaranA]

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

[CiaranA]

@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?

[JoeS]

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 🙂

[CiaranA]

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. 

[spandan92]

@jdunkerley79 

I have a query how to add a DROPDOWN feature into a batch macro so that i can dynamically input only 1 field.

Below i have described my situation, please help me out

• I have multiple database connections (read: for multiple markets), but the field names that i want to extract is same.
• So i built a batch macro which runs for all the connections but i dont need all connections at the same time instead i want only one connection (Market) to run at a time.

So, can i somehow built a dropdown to select a particular connection before running the workflow.