Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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.

Dates Check

AlteryxLearner23
7 - Meteor
‎07-11-2023 06:53 AM

Hi,

 

The attached file shows a load of data, with figures on the right side from Jan-2023 to Dec-2028.

 

Columns I and J are "Start Date" and "Exit Date".
I want to flag any rows that have data that IS NOT zero outside of the date range.

 

For example,

If a building has a Start Date of 1st Dec 2023 and Exit Date of 1st May 2025, then I would want to flag this row if there are numbers other than zero either before Dec 2023 or after May 2025.

 

Hope that makes sense!

 

 

Preview file
850 KB
Reply
0 Likes
1 REPLY 1
Prometheus
12 - Quasar
‎07-18-2023 08:51 AM

Quick question: Where are you looking for the numbers when you say, "then I would want to flag this row if there are numbers other than zero either before Dec 2023 or after May 2025"? Are you talking about the day value in the date being something other than "00"?

Reply
0 Likes
designer new user guide
Labels