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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Preparing data into multiple rows and back

Atom

Hi experts,

 

I have columns Client and Contact. Contact that may have comma separated names in it (e.g., "John Smith, John Doe, Jane Doe"). I would like to separate contact out to be one contact per line.

Input:

Client Contact
FruitCo John Smith, John Doe, Jane Doe

Output:

Client Contact
FruitCo John Smith
FruitCo John Doe
FruitCo Jane Doe

 

 

Also, how would you combine it back? (i.e., multiple line to just one line). We have not decided which form is better for us yet.

 

See attached excel for illustration.

 

I have 9.2 so if you can have demo yxzp in that, it would be great!

 

Thanks.

Tom

@datawork

 

i dont have 9.5 so please refer the below screenshots

 

One row row to Multiple Rows use Text To Columns tool under parse menu

1 to M.PNG

 

for Multiple row to 1 use Summarize tool and group by Client and Concat by Contact

M to 1.PNG

Labels