Alteryx designer Discussions

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

Create Field Based on Order of Records

Highlighted
8 - Asteroid

In the file attached, I have three instances of each state for each company.  For each state, I'd like to create a column where the first instance of each state says "Addition", the second instance says "Subtraction" and the third instance "Post-Apportioned Adjustment."  There are duplicates of each state when the entity name changes.  Can someone please provide some guidance?

Highlighted
11 - Bolide
11 - Bolide

See attached. it's basically a multi-row tool (grouping the main pieces) to get the field order, then a crosstab to roll up horizontal, then a select to rename the fields.

Highlighted
8 - Asteroid

Thanks very much.  I can't open your workflow because I am running on an older version of Alteryx.  Could you send me a screenshot of the multi-row formula and the cross tab tools?

11 - Bolide
11 - Bolide

no problem.

here's the multi-row:

clipboard_image_0.png

and here's the crosstab:

clipboard_image_3.png

The select:

clipboard_image_5.png

 

And the workflow:

clipboard_image_4.png

Highlighted
Alteryx
Alteryx

@bcrisman Attached is the workflow that does what you asked for. Is this what you are looking for?

Dataset.PNG

Digan
Alteryx
Labels