Update filter to match dynamic condition

[neilgallen]

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?

[T_Willins · Accepted solution]

Hi @neilgallen,

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

[neilgallen]

Duh.