community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Splitting Mixed Data into New Columns

Meteor

Hi all,

 

I am trying to take mixed data (numbers and states) and split them into two columns while assigning a state to each number. For example, Illinois below has 3 numbers above it in the input sample and I would like to move Illinois next to each number where it is applicable.  Final output should look like sample attached below:

Input.PNG                         Output.PNG

 

Any help is appreciated!

Quasar

Hi @tj3678 ,

This works with sample data .

Sort ( to get states on top )  , Multi row  ( adding states to zip)   , filter and sort  ( to get original order) .

benakesh_0-1573680057172.png

 

 

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @tj3678 I mocked up an example let me know what you think?

Meteor

Thanks! @JosephSerpis 

Labels