take the earliest date field and its corresponding fields

[KCAgentProvocateur]

Hi there, 

I have two opt in dates on my row and i would like to take the earliest date, with that i would like to take the opt in details. Same as opt out.

Can anyone help please?!

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

[JosephSerpis]

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

[KCAgentProvocateur]

almost perfect! but customer C has the incorrect Opt_In_Details

[JosephSerpis]

Hi @KCAgentProvocateur I updated the workflow as I noticed the results weren't quite correct. Could you please check again?

[KCAgentProvocateur]

Now customer A and B have incorrect opt in details!

[JosephSerpis · Accepted solution]

Hi @KCAgentProvocateur  apologies I had to redo the Alteryx workflow to answer your question this version should give the correct details in the output.

[KCAgentProvocateur]

amazing thanks!