topic Dynamic Select and Filter in Alteryx Designer Desktop Discussions

Dynamic Select and Filter

asifk — Thu, 24 May 2018 05:00:27 GMT

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

Re: Dynamic Select and Filter

asifk — Tue, 13 Mar 2018 10:12:49 GMT

FYI

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

Re: Dynamic Select and Filter

LordNeilLord — Tue, 13 Mar 2018 10:23:24 GMT

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

Re: Dynamic Select and Filter

asifk — Tue, 13 Mar 2018 11:59:57 GMT

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

Re: Dynamic Select and Filter

MelanieR — Thu, 05 Dec 2019 11:09:51 GMT

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?

Re: Dynamic Select and Filter

MelanieR — Fri, 06 Dec 2019 14:34:23 GMT

Hi,

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

Re: Dynamic Select and Filter

spandan92 — Wed, 06 May 2020 14:07:55 GMT

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