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 |
Solved! Go to Solution.
Hi @KCAgentProvocateur I mocked up a workflow that output the results you describe. Let me know what you think?
almost perfect! but customer C has the incorrect Opt_In_Details
Hi @KCAgentProvocateur I updated the workflow as I noticed the results weren't quite correct. Could you please check again?
Now customer A and B have incorrect opt in details!
Hi @KCAgentProvocateur apologies I had to redo the Alteryx workflow to answer your question this version should give the correct details in the output.
amazing thanks!