Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Help with combining 2 rows which have a UNIQUE IDENTIFIER for FIRST N CHARACTERS

MROGK
8 - Asteroid

Hi,

 

Can someone help me with this challenge in combing the two rows that have the same first 11 characters (identifier) in IP Number (Student XYZ matches on IP Number on first 11 characters)? I'm looking to create a single row in the output that gives me Min. Start Date and Max. End Date from the 2 rows. The sum & days will be cumulative. I posted the source table and result table in the excel attachment. Thanks.

3 REPLIES 3
Tyro_abc
11 - Bolide

Hi 

Please find attached, let me know if this works.

 

Tyro_abc_0-1649169815804.png

 

Regards

Arundhuti

binuacs
21 - Polaris

@MROGK  take the first 11 characters of the field IP Number and Group by using the Summarize tool will give your result

 

binuacs_0-1649171410674.png

 

MROGK
8 - Asteroid

Thankyou to both @binuacs & @Tyro_abc . It worked.

Labels