topic Re: Cross Tab with multiple rows in Alteryx Designer Desktop Discussions

Cross Tab with multiple rows

FabioP — Thu, 13 Jun 2019 13:31:56 GMT

Hello everyone!

Follows my need.

This is my input:

Desired output:

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

Could you guys help me?

LukeM — Thu, 13 Jun 2019 13:42:39 GMT

Attached is the solution.

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 — Thu, 13 Jun 2019 13:49:37 GMT

Hello,

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

Let me know if it works for you.

Irene

FabioP — Thu, 13 Jun 2019 13:50:13 GMT

Perfect!!

Thank you.

itestu — Thu, 13 Jun 2019 13:52:14 GMT

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 — Thu, 13 Jun 2019 14:01:23 GMT

Done!

tamits — Fri, 16 Sep 2022 14:11:26 GMT

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.