Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Create Start and End date column

Marianjz
5 - Atom

Hi everyone

I need to create 2 columns Start Date and End Date like the following:

 

ID             TYPE    CODE     STATUS       Start Date           End Date

17568020     B      ABCDE  Completed 1/23/2020 22:36  1/23/2020 22:46

 

The row data is the following

ID             TYPE    CODE     STATUS       Start Date 

17568020 B          ABCDE  Completed 1/23/2020 22:36
17568020 B          ABCDE  Completed 1/23/2020 22:37
17568020 B          ABCDE  Completed 1/23/2020 22:38
17568020 B          ABCDE  Completed 1/23/2020 22:39
17568020 B          ABCDE  Completed 1/23/2020 22:40
17568020 B          ABCDE  Completed 1/23/2020 22:41
17568020 B          ABCDE  Completed 1/23/2020 22:42
17568020 B          ABCDE  Completed 1/23/2020 22:43
17568020 B          ABCDE  Completed 1/23/2020 22:44
17568020 B          ABCDE  Completed 1/23/2020 22:45
17568020 B          ABCDE  Completed 1/23/2020 22:46

 

I need help!

Thanks in advance

 

4 REPLIES 4
danrh
13 - Pulsar

Look into the Summarize Tool. Group by your other columns (ID, Type, Code, Status), then take the MIN of your date column for your start date and the MAX of that same date column for your end date.

 

Hope it helps!

Dan

afv2688
16 - Nebula
16 - Nebula
 
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Marianjz,

 

I would approach it by summarising:

 

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

 

Marianjz
5 - Atom

Thank you!, works perfectly

Labels