We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Grouping, Transforming, and Describing

MsBindy
8 - Asteroid

I think I am overthinking some data manipulation I'm trying to accomplish.

 

I have a list of Change Orders on a project, each with a Change Order number and a standard description.

 

I would like to turn it into a table that groups the change order by that standard description, and then lists the change orders.  However, I don't just want to concatenate the change orders.  I want them to be listed a little differently if they are a contiguous range.

 

I've put some sample start data and the desired results in the attached workflow.

3 REPLIES 3
binuacs
21 - Polaris

@MsBindy one way of doing this

image.png

Raj
16 - Nebula

@MsBindy 
find the workflow attached
mark done if solved.

MsBindy
8 - Asteroid

Thank you both!  These are actually quite similar.

Labels
Top Solution Authors