Fields to be included in the drop down tool linked to filter tool

[h12]

Hi All

I have been able to configure my Drop Down tool which is linked to a fiter tool

I created a dummy file to use as the input (Fields from a connected tool)

I am basically looking to give the user the option to filter the data based on 2 of the fields. For example, they can either filer on Surname or Number. Once they choose either of those, they then enter the value  which would then update the filter tool accordingly.

Ask:

1. You can see from my first screenshot there are 4 options, I would ideally only like 2 of the options to show (e.g. Surname and Name)

2. Then once they select either of the two option, the user should be able to add the 'value' they would like to filter for. So the filter tool in the screenshot updates to Surname or Number based on what the user selects. I think I'll need to add another tool in, but I am not sure which one and where!

[atcodedog05 · Accepted solution]

Hi @h12 

You can directly specify values like below.

Here is a sample app.

Hope this helps : )

[h12]

Hi @atcodedog05 So I have tried to set it up similar to yours but it looks like the 'b' in the filter tool doesn't update to 'smith' when I run it.. not sure if I need to select anything within the action tools?

I also am unable to open your app because my alteryx might be an older version (sorry!)

[atcodedog05]

Hi @h12 

The issue with your flow might with the action tool config.

To open my app right-click on and click on edit like below. 

Hope this helps : )

[h12]

Thank you @atcodedog05 I have been able to set it up just as your one! (thank you for the instructions on how to open it!)

When I search for Surname = smith it filters it correctly, but when I do Number = 38495 I get the below error.. I have converted it to string and the below error stil comes up!

[h12]

I think I got the same error in your flow when I changed it to the Number field.. 

[h12]

Hi @atcodedog05 I think I found the issue.. it was replacing the letter 'b' in NUMBER with the number in the value, maybe because the filter was 'Surname = 'b'

I have changed it to Surname = 'testing' and It seems to work now!

[atcodedog05 · Accepted solution]

Hi @h12 

The issue is with column name Number when I changed to value it worked.

Hope this helps : )

[h12]

Hi @atcodedog05 Thank you! That also worked! Thank you for your help today!

[atcodedog05]

Happy to help : ) @h12 

Cheers and have a nice day!