Multi-Row Formula Help

[KmbrlyPC]

I am needing to combine data from 2 rows into 1. Where the Class #, Subject, and Assignment Description is the same, I need it in 1 row with the Status and Count combined. For example, Class #1 for Math for Addition & Subtraction I want to see the Status of Completed - 12, Pending-18 together instead of separated on a different line.

[Kenda · Accepted solution]

Hello @KmbrlyPC 

I would actually use a normal formula with a summarize tool here. 

First create a combined status and count field with a normal formula tool with this expression:

[Status] + " - " + ToString([Count])

From here, you can use a summarize tool to group by Class #, Subject, and Assignment Description then concatenate your newly created combined field.

Hope this helps!

[atcodedog05 · Accepted solution]

Hi @KmbrlyPC 

Here is how you can do it.

1. Using formula add status & count.

2. Using summarize tool groupby Class, Subject, Assigned group and concat status w/Count

Hope this helps 🙂

[mceleavey]

Hi @KmbrlyPC ,

A simple bit of crosstab magic did the trick:

Hope this helps,

M.

[dougperez]

I used summarize and formula to do the desired output.

[mceleavey]

I love how many different ways there are to do everything in Alteryx 🙂

[KmbrlyPC]

Thank you!!