Alteryx Designer Discussions

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

Update filter to match dynamic condition

neilgallen
12 - Quasar

I have a filter that needs to updated dynamically for a date. This date will be determined in a separate part of the workflow based on a custom calendar we use internally.

 

I could append this date to every record in my dataset and then filter where the dates match, but due to the number of records and size of fields (several hundred thousand records and 15+ fields), I'm trying to avoid creating new fields if I can help it. The append creates one more step I'm trying to avoid.

 

I was wondering if this could be done using an action tool, but all my research thus far has turned up nothing.

 

Thoughts?

2 REPLIES 2
T_Willins
14 - Magnetar
14 - Magnetar

Hi @neilgallen,

 

You could filter using a Join tool by matching the determined date field with the date in the data set.

 

Filter Using Join.png

 

neilgallen
12 - Quasar

Duh.

 

giphy

Labels