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

Split content of a cell into lines

Thomas_Feray
5 - Atom

Dear Alteryx community,

 

Here is my problem today, I've tried several ways, but did not get the expected result:

  1. I have several columns which include several rows of data
  2. Each row has multiple lines of data in it
  3. I would like to be able to separate each line of data from each row
  4. Each line of data should be, eventually, a row. 

I include an excel file to be more explicit about my request. The first tab show how the data that I have is extracted and the tab "Expected results"... well... shows the objective I would like to achieve! 😁

 

Any idea as to how to proceed?

 

TF

 

4 REPLIES 4
DavidSkaife
13 - Pulsar

Hi @Thomas_Feray 

 

Here is a way of doing it:

 

Split each column into rows using the Text to Columns tool with a delimiter of \n

Deselect unwanted fields from each stream

Join back together on Record Position using the Join Multiple Tool

Tidy up the columns using a formula tool and the Substring function

DavidSkaife_1-1663703556475.png

 

ConnorK
Alteryx
Alteryx

Hi @Thomas_Feray ,

 

Please take a look at the attached workflow. The best way I find to do this is by Transposing all the columns into one row, then using the Text-to-Columns tool to split into rows. From there you can Cross-Tab the data back into its original layout.

 

Best,

Connor Kelleher
Senior Sales Engineer
Alteryx
Thomas_Feray
5 - Atom

Hi @DavidSkaife,

 

Thank you very much for the solution, it works very well!

 

Regards,

 

Thomas

Thomas_Feray
5 - Atom

Hi @ConnorK, 

 

This solution works as well! Thank you for the time spent to solve my problem!

 

Regards,

 

Thomas

Labels