Reset Select Tool to Default in Analytic App

[AMcGuane]

Hi,
I am developing an analytic app where I have both consistent variables and dynamic variables. I'm currently using a dynamic select to allow for a list box to select the dynamic variables that the user wants to include in the report while keeping the standard "mandatory" variables non-toggleable.

For example:
Data set one has Name, Age, Address, Favorite Food, Favorite Color,
Data set two has Name, Age, Address, Favorite Color, Favorite Animal, Jean Preference

The report would always include Name, Age, and Address as the standardized variables but:
I want when I run the App on data set one to be able to choose between Favorite Food and Favorite Color
and when I run the App on Data set two I want to only see Favorite Color, Favorite Animal, and Jean preference.
Therefore - I don't want Favorite Food to come up as an option when I run data set 2 because it was previously run through the SELECT statement?
Is this how its already done? Or is there a way to configure it to behave the way I need it to?

thanks! 

[apathetichell · Accepted solution]

you're a bit far from where you need to be to get what you want.

I wouldn't touch the select tool. I'd do the following.

1) chained app.

app 1) -- get file. --- it will create your list for listbox.

you will filter our your key fields that are static so they don't show up in your listbox.

2) app 2) - you will take in the file from app 1)

you will take your data from file--- and it will go into a dynamic select tool.

you will use the formula:

(can't remember if it's [_CurrentField_] or [Name])

[Name] in ('Name','Age, and 'Addres') or [Name] in ('TEST')

next --- configure your listbox in LIST mode --- not select mode. use "     ","     " as the delineators

use an action tool --- connect to dynamic select. replace a specific string. replace 'TEST' --- include your quotes. you must include your quotes. 

Sorry I can't help you with a template/example.