Alteryx: Is it possible to pivot the data without aggregating?

Question ID: 109601

I have data with the structure in the attached file. How can I make it look like the second file as concisely as possible? Whenever I try to use Crosstab tool it tries to sum or concatenate.

Marked as spam
Posted by (Questions: 7, Answers: 0)
Asked on June 10, 2020 6:02 pm
Private answer

The most efficient way to accomplish this is with a combination of Multi-Row Formula and a Cross Tab tool.

Using the formula in the Multi-Row Formula tool, you will get a unique record ID for each city. Then you can use the crosstab tool to group on City and Record ID while using the Metric field for your column headers and the Value field for your values. Finally Use concatenate as the method for aggregating.

The output should match the desired output you posted above.


Hope that helps!

Marked as spam
Posted by (Questions: 0, Answers: 7)
Answered on June 11, 2020 5:02 pm