Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Using Filters

traceystone
8 - Asteroid
‎09-13-2021 09:11 AM

Hello,

 

Seeking help with a custom filter. I need to filter out everything in the [Asset Status] column that is = "Retired" and has a [Scheduled Retirement date] < "01/01/2020". I have attached the workflow and a snapshot of what the data looks like in those 2 columns. What I have doesn't seem to be working.

Service Now Asset Data.yxmd
44 KB
Labels:
Reply
11 REPLIES 11
traceystone
8 - Asteroid
‎09-13-2021 11:13 AM

I attached the spreadsheet, workflow, the formula, and the errors I am getting.

Service Now Asset Data.yxmd
1788 KB
30 KB
73 KB
Reply
0 Likes
MatthewBr
Alteryx Alumni (Retired)
‎09-13-2021 11:24 AM

you provided only one of the 2 spreadsheets ?

 

MatthewBr_0-1631557435946.png

 

Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels