Pivot Table

Question

Hi all

I’m trying to create a pivot style table in alteryx but can’t seem to figure it out. An example of my data is shown below:

MonthIDDayJanuary2343January2682January2342January9871January9873February9871February2683February2343March9872March2682March2681March2342

I want it to look like:

IDJanuaryFebruaryMarch234332987312268232

Where the values in each month column are the MAX day values for each ID

Appreciate if anyone could help please?

Kenda · Accepted Answer

Hey @walkrebe

The Cross Tab tool will help you out here!

First, you will want to sort your records as follows:

Month - Ascending

ID - Ascending

Day - Descending

Then, add a Cross Tab tool and select ID as the field to Group by, select Month as the Headers, and Day as the Values. Finally, you'll want to select First as the Method for Aggregating Values. Unfortunately there is no Max option here, and that is why we needed to sort the data first.

Hope this helps!

atcodedog05 · Accepted Answer

Hi

Here is a workflow for the task. It maintains the months sort order by using a header template.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍