Using a variable in filter tool

reedy212

Looking for ways I can get a date range from a look up table then use those start and end dates in a filter.

In SQL I would
declare @startdate date
Set @startdate = (Select startdate from Lookup where period=1)

then I could get data where date >@startdate

Attached a pseudocode example.

VariableFilter.yxmd

Workflow

Help

Preparation

Accepted answers

npariso

Hi @reedy212 the first thing you would need to do is append the user inputted dates for filter to the source data set.

The attached solution should accomplish what you are looking for. Let me know if not and we can rework it.

VariableFilter Proposed Solution.yxmd

All comments

binu_acs

@reedy212 You can use the min and max of the field End_Date

VariableFilter.yxmd

npariso

Hi @reedy212 the first thing you would need to do is append the user inputted dates for filter to the source data set.

The attached solution should accomplish what you are looking for. Let me know if not and we can rework it.

VariableFilter Proposed Solution.yxmd

reedy212

I think this would work, but only for a limited set of analysis periods. My example was simplified, but fully fleshed out I would require the option to run the workflow with any analysis period for an entire year. Min and Max enddate wouldn't work for a middle of the year analysis period.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703