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
RishiK
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!

RishiK
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