We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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