Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Transpose certain columns into rows


i have an issue i have rows that contain 2 columns for a phone number and an alternate. The name and user info is all the same but the user might have 2 numbers. 

If column 2 is populated with a second number i would like to duplicate the entire row but have only one phone number field. 

so if :


aaaa 1111
bbbb 2222 6666
cccc 3333
dddd 4444 7777
eeee 5555 8888


then i would like the final result to be something like:

aaaa 1111
bbbb 2222
bbbb 6666
cccc 3333
dddd 4444
dddd 7777
eeee 5555
eeee 8888

Alteryx Certified Partner
Alteryx Certified Partner


Step #1:  Use a TRANSPOSE tool.

Screen Shot 2017-01-17 at 1.19.00 PM.png

Step #2:  Use a Filter tool

Screen Shot 2017-01-17 at 1.20.02 PM.png

Your output will look like this:

Screen Shot 2017-01-17 at 1.21.00 PM.png


This gets you directionally to where you want to be.  Is the value a Phone Number, could be tested and any non-phone records could be eliminated.  





Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.