Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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