community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Cross Tab with multiple rows

Atom

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?

Alteryx
Alteryx

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

Alteryx
Alteryx

Hello,

 

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

Let me know if it works for you.

 

Irene

Atom

Perfect!!

 

Thank you.

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 !

Atom

Done!

Labels