Dynamic Filter change / Date - Auto

[STAR1BANU]

Dear Experts,

I have attached the sample data I need a solution

Every month if I run the Alteryx Workflow if the current month is Jan 2021 the workflow automatically filters the details from DATA A SHEET for Jan month only and filter the details from DATA B SHEET and joined them both based on the name and give the Output Required for Jan and Output Required for Feb likewise if I run the workflow in the month of Mar to Dec 2021 it will pick the data and give the output without any manual help

Please suggest how to apply the dynamic filter and date formula at the earliest

[AngelosPachis]

Hi @STAR1BANU ,

I believe what you are looking for is a dynamic select tool. This tool will allow you to define an expression for the column headers, and the tool will only contain the fields that satisfy that condition.

For example, if you want to keep the columns [Name] and then all columns that contain the 3 letters of the month we are in at the time the workflow is run, the expression you should use is

Contains([Name],Datetimeformat(Datetimetoday(),"%b")) OR [Name]="Name"

The first part of the expression, reading it from the inside-out, will get you today's date, then keep only the 3 letters for the month (Jan, Mar, Jun) and select only the columns that contain those 3 letters.

In the provided dataset it does not work because you don't have data for March, but if you test it on another dataset it should work.

Let me know if that worked for you.

Cheers,

Angelos

[Qiu · Accepted solution]

@STAR1BANU 

A bit different one