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.

Interface Tools

Accepted answers

jdunkerley79

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

DynamicDropDown.yxzp

All comments

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

ListBox.yxmd

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.

jdunkerley79

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

DynamicDropDown.yxzp

CiaranA

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

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703