Hi! I'm new to Alteryx and would very much appreciate some help. Based on the attached spreadsheet, I'm trying to: * Make column heads out of each unique date in the date column, plus a column head for no date (denoted by a dash) * Make a row for each unique name in the name column * Fill in the columns/rows with a count of the number of times each unique date appears for each unique name Thank you in advance for any advice! Question.xlsx

Creating a grid with counts from two columns of data

jryan_jl

Hi! I'm new to Alteryx and would very much appreciate some help.

Based on the attached spreadsheet, I'm trying to:

Make column heads out of each unique date in the date column, plus a column head for no date (denoted by a dash)
Make a row for each unique name in the name column
Fill in the columns/rows with a count of the number of times each unique date appears for each unique name

Thank you in advance for any advice!

Question.xlsx

Workflow

Developer

Reporting

Common Use Cases

Accepted answers

CoG

This is a great use case for the Cross Tab Tool. The only extra step necessary would be to add another field via the Formula Tool called "Count" (or whatever you prefer) to track the frequency of each name via the Cross Tab Tool. Note: Cross Tab tool has weird renaming effect, where "_" replace all non-alphanumeric characters, so we can Use the Dynamic Rename Tool to fix that.

Also, note you have two options for output. Cross Tab uses nulls for values that do not otherwise exist. If you want to replace with nulls, then you can use the Multi-Field Formula Tool.

Hope this helps and Happy Solving!

Sample Workflow.yxmd

All comments

CoG

Also, note you have two options for output. Cross Tab uses nulls for values that do not otherwise exist. If you want to replace with nulls, then you can use the Multi-Field Formula Tool.

Hope this helps and Happy Solving!

Sample Workflow.yxmd

jryan_jl

Thanks so much! I'll try it out!

jryan_jl

This worked perfectly! Thanks again! 😁

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703