ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic Filter from Field Values

melville
6 - Meteoroid

Hello Alteryx Community!

 

I'm looking to understand how to create a dynamic filter from fields within a table. 
I currently have four fields each containing a single string. Each of these strings
would become a filter for a seperate table.

 

This is my first question for the community so I hope this is clear and quite straight forward. Thank you.

 

Tbl containing strings required for filters

clipboard_image_1.png

 

Required Filters

clipboard_image_2.png

 

Highlighted Yellow is the required dynamic content.

clipboard_image_4.png

4 REPLIES 4
rkapoor
Alteryx
Alteryx

Hi there

 

I knocked up the attached workflow quickly for you.

 

You can transpose the column and values and apply a filter based on that maybe?

melville
6 - Meteoroid

Thank you for the fast reply. This solution would still require manually updating the cell values in the filter tool with '[Value] = 'August, 2019''.

 

I'm looking to have these filters updated based on refreshed content without manual intervention.

 

Thank you!

rkapoor
Alteryx
Alteryx

I've made some amendments.

 

Will this work for you?

melville
6 - Meteoroid

Thank you - a really simple solution and one I wasnt looking at solving this way. I had been focused on the interface and developer tools without success.

 

Thanks again!

Labels
Top Solution Authors