Analytic App - Dynamic Checkbox List

[DennisK]

Hello,

I'm trying to build a dynamic app that will identify available fields and based on those fields will return a certain output.

The problem is that I need to dynamically populate the check box list tool with the available fields from a file. I set all it to "All Checked by Default" because that is a tricky way to transfer from regular tools (input tool in this case) to Interface tools (to use Condition tool later for closing not relevant containers)

Here is a screenshot of the relevant part of the app:

You can see that I have 2 files that contain the fields list and the sheetlist, and both connect to a check box list tool, that will later connect to a condition and to an action over a container.

Configuration of the check box list tool:

Configuration of the Condition tool (for reference)

I really hope there's a solution within Alteryx 🙏🙏

Thanks

[DavidSkaife · Accepted solution]

Hi @DennisK 

By selecting available fields, are you meaning the data held within those fields; i.e not the field types instead the values in the field?

If that's the case yes you can connect the List Box to an external source to dynamically select specific fields; the list box example in Alteryx has some info on this, but you essentially select the following in the tool and point it to the external file:

You're input needs to mimic the configuration for manually set values, with a name and a value field in order for it to work.

[DennisK]

I connected the list box to the intermediate file instead of connecting from an input file and it worked.

I just had to figure out how to create the correct format for it to read the name and values and it seems that I just need to create 2 column data file with "Name" and "Value" field names.

Thanks!