Dynamic Select and Filter

[asifk]

Hi Team,

I have just received a request from a Client, 

They require me to build an App whereby I can filter by selected Column Name and thereafter by data within that column,

My first filter would be to select the column which I want to search on

My Second filter would be to search by the text I have entered

I am able to successfully read in the field names and have a list box with names, I am having trouble with trying to filter 

Eg.

Filter 1: Select Company No

Filter 2: "456"

Name	Company No	Status
ABC	123	A
DEF	456	A
GHI	789	D
JKL	000	D

[asifk]

FYI 

The result will be rows of data that match the input by user

[LordNeilLord · Accepted solution]

Hey @asifk,

Something like this should work for you:

• I have the input connected to a drop down list which will allow the user to select their field...this updates the "field" in the filter
• I have a text box connected to the filter which updates the value

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[asifk]

Ho Neil

This is FANTASTIC! 

Thanks very much!!!

I now understand the selections on the Action Tool being "field value"  & "operand value"

I learnt so much through this 1 workflow.

Have a great Day!

Regards,

Asif

[MelanieR]

Hi,

I am very interested by the solution proposed as it almost answer my problem.

I would like to implement a dynamic filter for which user could chose the value thanks to a list box tool. 

Then I tried to replace the text box tool with the list box tool but it's not working. Could someone help me on that point please?

[MelanieR]

Hi,

I finally found what was wrong. No open question anymore 🙂🙂

[spandan92]

Hi Asifk

Could you please share the workflow file? I am building something similar but its not working. I need to see the settings that are done for building this app.

Thanks