ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Grouping, Transforming, and Describing

MsBindy
Astéroïde

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 RÉPONSES 3
binu_acs
Polaris

@MsBindy one way of doing this

image.png

Raj
Nébuleuse

@MsBindy 
find the workflow attached
mark done if solved.

MsBindy
Astéroïde

Thank you both!  These are actually quite similar.

Étiquettes
Auteurs des meilleures solutions