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.
SOLVED

Transpose certain columns into rows

Highlighted
Asteroid

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

@spetkae09

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.  

 

Cheers,

Mark

 

Alteryx ACE & Top Community Contributor

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