We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start 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
Live Office Hours
Labels
Top Solution Authors
View All