Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

take the earliest date field and its corresponding fields

KCAgentProvocateur
8 - Asteroid

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:

 

CustomerLeft_Opt In DateLeft_Opt In DetailsLeft_Opted Out DateLeft_Opt Out DetailsRight_Opt In DateRight_Opt In DetailsRight_Opted Out DateRight_Opt Out Details
a10/29/2018 05:09 PMAdded by Webforms01/20/2019 07:28 PMopt out click12/25/2018 02:13 PMadded by user  
b11/19/2017 05:09 PMAdded by Webforms05/25/2018 04:21 PMopt out click12/25/2018 02:15 PMadded by user01/22/2018 03:25 PMunsubscribe
C06/22/2018 05:09 PMAdded by Webforms  02/20/2018 05:09 PMadded by user  

 

Required output:

 

 Opt In DateOpt In DetailsOpted Out DateOpt Out Details
a10/29/2018 05:09 PMAdded by Webforms01/20/2019 07:28 PMopt out click
b11/19/2017 05:09 PMAdded by Webforms01/22/2018 03:25 PMunsubscribe
C02/20/2018 05:09 PMadded by user  
6 REPLIES 6
JosephSerpis
17 - Castor
17 - Castor

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

 

 

KCAgentProvocateur
8 - Asteroid

almost perfect! but customer C has the incorrect Opt_In_Details

JosephSerpis
17 - Castor
17 - Castor

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

KCAgentProvocateur
8 - Asteroid

Now customer A and B have incorrect opt in details!

JosephSerpis
17 - Castor
17 - Castor

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
8 - Asteroid

amazing thanks!

Labels