Merging multiple fields into one column takin earliest date then renaming field content

[KCAgentProvocateur]

Hello, 

hoping this isnt too complicated, or at least my explanation is clear enough.

I have multiple columns which contain dates eg:

Customer	sale	ss18	ss19	offer
1	06/11/2017
2		07/11/2017
3			08/11/2017
4				09/11/2017
5		07/11/2017		09/11/2017

But i only need to take the earliest date - then populate the field with the head column name eg:

Customer	New_Field
1	Sale
2	ss18
3	ss19
4	offer
5	ss18

Can anyone help me out? as im not sure where to start!

[JosephSerpis]

Hi @KCAgentProvocateur I mocked up a workflow that produces the output as you describe. Let me know what you think?

[cplewis90 · Accepted solution]

Hey @KCAgentProvocateur,

I have attached a workflow that will sort the dates and only give the first option for each (the earliest option). Let me know if you have any questions.

[KCAgentProvocateur]

amazing thanks both - both work amazingly!

[KCAgentProvocateur]

on this topic - could you also tell me how to change a string field containing: 06/25/2-19 11:43 AM and change it to date format, but i need to keep it in that format. I tried the date time tool but it didnt seem to work.

[cplewis90]

Here is a workflow that would change a date time to a working datetime field in Alteryx.

[KCAgentProvocateur]

I actually need a similar workflow to this - but i dont need to rename at the end. 

Instead i have the below fields:

Left_Opt In Date

Left_Opt In Details

Left_Opted Out Date

Left_Opt Out Details

Right_Opt In Date

Right_Opt In Details

Right_Opted Out Date

Right_Opt Out Details

I need to take the earliest opt in date and the opt in details next to that - then the same for opt out date and details.

Thanks in advance!

[cplewis90]

Can you share some sample data and the result you are looking for?

[KCAgentProvocateur]

sample data:

Customer	Left_Opt In Date	Left_Opt In Details	Left_Opted Out Date	Left_Opt Out Details	Right_Opt In Date	Right_Opt In Details	Right_Opted Out Date	Right_Opt Out Details
a	10/29/2018 05:09 PM	Added by Webforms	01/20/2019 07:28 PM	opt out click	12/25/2018 02:13 PM	added by user
b	11/19/2017 05:09 PM	Added by Webforms	05/25/2018 04:21 PM	opt out click	12/25/2018 02:15 PM	added by user	01/22/2018 03:25 PM	unsubscribe
C	06/22/2018 05:09 PM	Added by Webforms			02/20/2018 05:09 PM	added by user

Required output:

	Opt In Date	Opt In Details	Opted Out Date	Opt Out Details
a	10/29/2018 05:09 PM	Added by Webforms	01/20/2019 07:28 PM	opt out click
b	11/19/2017 05:09 PM	Added by Webforms	01/22/2018 03:25 PM	unsubscribe
C	02/20/2018 05:09 PM	added by user

Thanks,

[KCAgentProvocateur]

Does the above make sense?