Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

separating a single row into multiple

Dannen_Shatto
5 - Atom

I have an excel sheet as an input. Each row represents a different book (about 1,000). One of the fields is genre and multiple genres are listed for each book in a single cell (ex. cell C4 includes "nonfiction,politics,history"). Is there a way I can split this into multiple rows based on genre? I'm wanting each row to only list one genre, even if I need to have multiple rows of the same book.

 

Please let me know of any useful tools for this.

 

Thank you!

2 REPLIES 2
ggruccio
ACE Emeritus
ACE Emeritus

Hi @Dannen_Shatto

 

I'd look at the Transpose tool. 

 

For instance the following workflow may produce the output you want.

 

ggruccio_0-1586956553954.png

Text Input:

ggruccio_1-1586956595804.png

 

Configuration of Transpose:

 

ggruccio_2-1586956640231.png

Output (in Browse):

ggruccio_3-1586956669354.png

 

 

 

 

 

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @Dannen_Shatto ,

 

you can use a Text To Columns tool to split the column containing comma separated entries, and set it to "Split to rows". I've attached a sample workflow. Let me know, if it works for you.

 

Best,

 

Roland

Labels