Transpose or cross-tab: help with a simple issue

[essemMLB]

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:

Value	Count
1	100
2	200
3	300

I want to flip it so that it looks like:

count_1	count_2	count_3
100	200	300

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?

[BenMoss · Accepted solution]

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 · Accepted solution]

Hi @essemMLB ,

This should do the trick for you.

Josh

[essemMLB]

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