Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Quick and Simple Data Transform

Highlighted
8 - Asteroid

Hi,

 

Just wondering if someone can help me by either referring me to an article at or a simple workflow to give me some insight.  It seems simple enough but am struggling a bit.

 

Thanks,

Jeff

 

I have some data that looks similar to:

 

2019-01-21_11-23-27.png

 

 

I'd like to transform it to:

AreaMonthPF
EastJan4522
NorthJan5010
SouthJan9010
WestJan100

20

Highlighted
Alteryx Partner
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @jeffv

 

Use Cross Tab tool to perform what you want.

 Ctab.PNG

See how I reversed back and got what you wanted wtih Transpose and Cross Tab tool.

WF appended.

Cheers,

Labels