Alteryx Designer

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

unique value in row transpose to column

Highlighted
5 - Atom

Hello,

 

I have a case where I exported data where everything is in 1 column. I was able to sequence it that every 4 rows, should be its own column

so data I have:

1.Anna
2.Smith
3.Analyst
4.Seattle
1.John
2.Doe
3.Manager
4.Dallas
1.Chris
2.Wallis
3.Accountant
4.San Francisco

 

What I want

1.2.3.4.
AnnaSmithAnalystSeattle
JohnDoeManagerDallas
ChrisWallisAccountantSan Francisco

 

 

Thank you!

Highlighted
Alteryx Certified Partner

You also need to add a record id field to group by, and then you can use the Transpose:Crosstab tool.

 

Unique Value in Row Transpose to Column.png

Highlighted
13 - Pulsar

Here is the sample workflow for your case.  Hope this is helpful. 

 

WorkflowWorkflowResultsResults

Labels