Transpose or cross-tab: help with a simple issue

Question

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:

ValueCount110022003300

I want to flip it so that it looks like:

count_1count_2count_3100200300

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 Answer

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

123100200300

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

Ben

JoshuaGostick · Accepted Answer

Hi @essemMLB ,

This should do the trick for you.

Josh