community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Quick and Simple Data Transform

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
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