List Box tool not picking up dynamic input from drop down

[saachitalwar]

I have some data that has a column which defines all the regions an event belongs to.

I want the user to select one or more regions from a drop down menu (analytical app) and that should give him an output that contains events only from the selected region(s) 

I have attached the wf where I'm implementing the list box for this purpose.

The issue is, the final output reflects only the regions I've hardcoded into the wf as placeholder, not the dynamically entered regions from the analytical app dropdown.

Any insights into this are appreciated

Thanks!

[Yoshiro_Fujimori]

@saachitalwar ,

Your filter condition is

  [Regions] = "BT"

This should be replaced with 

  [Regions] IN ("BT")

as the selected values from List Box tool is passed in list format.

I hope this helps.

[saachitalwar]

Hi, I changed the filter tool as you mentioned but the output is still according to the hardcoded regions and not dynamically selected ones

[saachitalwar]

Should I add an action tool for this to work?

[GMG0241 · Accepted solution]

Hi Saachitalwar,

the issue looks like to me that you hadn't correctly configured the action tool. Please see the attached .yxwz which now seems to be correctly filtering the data 

[saachitalwar]

This worked! Thank you so much. I wasn't aware about the formula part of the action tool.

[GMG0241]

No worries, I will add that the reason why the initial workflow wasn't working wasn't because you were using update value instead of the formula option, it's because the configuration of the action tool wasn't correct. When configuring the action tool, you need to make sure you select which bit of the tool (in this case the filter tool's formula field) you want to update. Once that's done, you can craft how you want to update it. In this case, I decided to use a formula, but I could have changed the filter tool to be [Regions] IN ("BT") as outlined by @Yoshiro_Fujimori, and then used the replace value update option to replace a specific string of "BT". Both options are equally valid, and I would recommend taking a look at the interactive lesson on analytic apps (https://community.alteryx.com/t5/Interactive-Lessons/Using-Analytic-Applications/ta-p/243106) for a more in-depth explanation of how the action tool works.

You can also debug the workflow to see exactly how the action tool has updated your tool by going to interface designer and clicking the wand on the top left of the screen followed by Open Debug which will open a new debug workflow which shows how the tools have been updated with the action tool (if you can't see the Interface Designer container, click view>Interface Designer at the top of the screen, or use the shortcut Ctrl+Alt+D).