Multi-Row Formula Help

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.

Help

Accepted answers

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!

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 🙂

All comments

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!

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 🙂

A simple bit of crosstab magic did the trick:

Hope this helps,

M.

mceleavey_solution.yxmd

I used summarize and formula to do the desired output.

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

Thank you!!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703