Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Transpose or cross-tab: help with a simple issue

essemMLB
7 - Meteor

OK, I have what I'm sure is a simple issue but I'm having trouble figuring out how to get it working right in Alteryx.

 

I have a table like this:

 

ValueCount
1100
2200
3300

 

I want to flip it so that it looks like:

 

count_1count_2count_3
100200300

 

I assume this is done with the cross-tab tool, but I'm having trouble getting it to come out this way. I tried with the transpose tool too. Help?

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

Correct you need to use the cross-tab tool.

 

Without any ammendments you need to select the 'Value' field as your header field, and the 'count' field as your value field.

 

This would give you something like...

 

1 2 3
100 200 300

 

You could then use the dynamic rename tool to add the prefix 'Count_' too all of your field names.

 

Ben

JoshuaGostick
11 - Bolide

Hi @essemMLB ,

 

This should do the trick for you.

 

Josh

 

essemMLB
7 - Meteor

I see! My error is that I was grouping values by the 'Value' column. Can we chalk this up to Friday brain?

Labels