Alteryx Designer Discussions

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

Using Crosstab function to transform multiple rows into 1 row

tessa
8 - Asteroid

Hi All,

 

I've browsed similar solutions to my problem and I have had no luck with my specific problem! 

My data set looks like this:

Device NumberAccount Number
30023D987
30023D719
30023D842
8330D299
8330D354

 

And I need to get it to look like this:

Device NumberAccount Number 1 Account Number 2 Account Number 3
30023D987D719D842
8330D299D354Null

 

Please help!

 

-Tessa

5 REPLIES 5
MarqueeCrew
19 - Altair
19 - Altair
If at first you crosstab and use the concatenation function you can follow up with a text to columns tool to finish the job.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
jdunkerley79
16 - Nebula
16 - Nebula

I would do the following:

2019-01-03_21-33-50.jpg

 

Use a MultiRow formula to create a Column id (e.g. 1, 2, ...) grouped by Device ID

Then Cross Tab

Finally use a dynamic rename to sort out the name

 

Sample attached

Thableaus
17 - Castor
17 - Castor

Here's the solution I thought.

 Solution.PNG

Cheers,

tessa
8 - Asteroid

Thank you- this solution worked out perfectly for me. Much appreciated! 

 

-T

ponraj
13 - Pulsar

Here is my version.

 

workflow.PNG

Labels