In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Crosstab for multiple columns

nataliad18
8 - Asteroid

Hi!

I have a rather complex dataset as it has *A LOT* of information (see attached file tab "input" as sample). 

I want to crosstab several key information to have desired output (see attached file tab "output" as sample).

N.B the file I attached is dummy data so Input tab is a small sample of the full tab and output file does not reflect correct "agree", "disagree" etc values from the input tab

 

I can only do crosstab for one, is there a way to do it in order to get a desired output in minimum amount of tools without having to use 100 summarize tools instead?

Thank you so much,

Natalia :) 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

Hi Natalia,

 

Are the numbers the count of respondents. Maybe this works?

image.png

nataliad18
8 - Asteroid

This worked perfect! Thank you, Philip - massive help, as always 😁

Labels
Top Solution Authors