Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Filtering relevant year

SH_94
11 - Bolide

Dear community,

 

Would like to ask how do we filter only year not later than 2022 as below:

Input

SH_94_0-1672803033239.png

 

Thank you.

3 REPLIES 3
ShankerV
17 - Castor

Hi @SH_94 

 

Please find the expected solution

 

ShankerV_0-1672803744128.png

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

Sarreddy
9 - Comet

@SH_94 

DataNath
17 - Castor

@SH_94 If you want not later than 2022 it would be:

 

[Year] <= 2022

 

or you could use:

 

[Year] < 2023

Labels