Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Date comparison/specific order

JamesCopeland67
5 - Atom

Objective: Compare sequence of dates that date 1 has to be the furthest out and date 6 the earliest and return any errors.

 

example:

 

Record 1 no issues

Record 2 no issues but missing data

Record 3 Date 4 is an issue

Record 4 No issues except no data in Dates 4, 5, and 6

Record 5 No issue except dates 5 & 6 are the same

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @JamesCopeland67 

 

Can you provide the expected output?

JamesCopeland67
5 - Atom

just need to return as in record 3 that date 4 is an error and record 5 the dates in 5 & 6 match which is also an error

JamesCopeland67
5 - Atom

in other words adding a column that says "is it good" yes or no and if no where the error is

Labels