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
20 - Arcturus

@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