Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

converting 1 column into several

Highlighted
Meteor

I have a data set weather data.  The monthly data is in a few long columns (month, fiscal year, avg temp).  I need to break those long columns up into several short ones (month, FY14 avg temp, FY15 avg temp, etc.).

 

I'm having trouble doing this.  Any help would be appreciated.

Thank you.

 

 

Highlighted
Alteryx Alumni (Retired)

The Cross Tab tool will do this.

You group by what you want your rows identified (in your case, it sounds like Months).

Then you have your Years as the Header and the Temp as the Values.

Quick example is attached.

Labels