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

Cross Tab with multiple rows

FabioP
8 - Asteroid

Hello everyone!

 

       Follows my need.

 

This is my input:

in.PNG

 

Desired output:

out.PNG

 

I don't know if is possible to config the Cross Tab tool to do this.

Could you guys help me?

6 REPLIES 6
LukeM
Moderator
Moderator

Hi @FabioP,

 

Attached is the solution.

13-06-19.PNG

 

1. Use Multi Row Formula tool to assign a Row number each time the A1,B1,C1... starts again.

2. Crosstab using the new Row number to group each separate row.

3. Deselect the Row column.

 

Hope this helps and you can apply it to your use case. Let us know how you get on.

 

Luke

itestu
Alteryx
Alteryx

Hello,

 

I have enclosed an example on a sample of your data. 

Let me know if it works for you.

 

Irene

FabioP
8 - Asteroid

Perfect!!

 

Thank you.

itestu
Alteryx
Alteryx

Could you tag our post as "solution" (you can star them")  so people know that you had a solution to your question.

Thank you !

FabioP
8 - Asteroid

Done!

tamits
6 - Meteoroid

Hello, which solution worked out for you? Could you please point me out the solution as i am also having same issue and the data is too huge.

Labels