We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

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
20 - Arcturus

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