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

Concatenate, minimum (Start Time) and maximum (End Time)

udles5666
8 - Asteroid

Hi Community 

 

I am trying to built a tracer model and need help please. 

 

Can you please refer to the attached package and help me populate 3 columns 

 

1. Concatenate and transpose - Zones Accessed
2. Start Time - Which i think will be min 

3. End Time - Which i think is max.

 

Attached screenshot of desired outcome. Thanks heaps in advance. 

 

Desired Output_Contact Tracer.jpg

5 REPLIES 5
ChrisTX
15 - Aurora

Do you want one record for each unique combination of:

  Card Number

  Name

  Company

  Exact Date

 

Try the single Summarize tool in the screenshot below.

 

If your Min and Max should include the Exact Date (not just the time), you'll need a formula tool to combine the Exact Date and time fields into DateTime data type.

 

Tracer Model - ChrisTX.png

 

Chris

udles5666
8 - Asteroid

Hi @ChrisTX 

 

Thank you for your response. 

 

Grouping By does not work unfortunately as I want all the rows for the data set. I would need to further model that on Start Time and End Time.

 

How do i do that? 

 

Attached for reference again.  Thanks, 

grazitti_sapna
17 - Castor

Hi @udles5666 , what if what I am thinking is correct you want to have start and end time of the person as if first time the person accessed a zone and last time the person accessed the zone, I do not think that concatinating the zones will be a great idea rather than grouping by card number, name, min_datetime and max_datetime can give you the result something like this.

Suppose Angelina Jolie's 09/09/2020 06:34:07 is the first time when accessed a zone and 09/09/2020 23:59:29 is the last time when accessed a zone.

Is this what you were looking for?

 

grazitti_sapna_0-1599806903472.png

 

 

Thanks

 

Sapna Gupta
ChrisTX
15 - Aurora

If you want the output to include all rows from the input, keep the Summarize like I mentioned then add a Join tool.  The Join left input would be the original data set.  The Join right input would be the stream from the Summarize.  Keep all of the left fields, and pick up the 3 fields you need from the Summarize.

Join on a key field like Card number.

 

Chris

udles5666
8 - Asteroid

Closing this post off. The below one is relevant and would help getting the answer if someone in the community is working on something similar. 

Thanks, 

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/COVID-Contact-Tracing-Model-Not-sure-w...

Labels