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

New line within the same cell

Savannah
8 - Asteroid

Hello 

 

I have been trying to look at other posts for this topic, but was unable to find a solution. 

 

I have text in one Excel cell:

 

01/01/22: knioaivneioiekiadfnkdhi iofnenwoij oiehfeinfeio idioem
2/1/22: cimkcibm eknkgoeg fkeing
3/1/22: ckkmvkeg eifknke

 

I want it to stay in that format. Now, Alteryx just takes all the text in one string and doesn't divide it up. 

 

I've attached sample Excel file. 

 

Many thanks for any suggestions! 

 

9 REPLIES 9
atcodedog05
22 - Nova
22 - Nova

Hi @Savannah 

 

Here is how you can do it.

Make sure to set the input tool as First row contains data.

atcodedog05_0-1642586876857.png

 

Then split to new lines in regex

atcodedog05_1-1642586903801.png

 

Hope this helps : )

Savannah
8 - Asteroid

Hi!

 

Sorry, I was unclear, I need the lines to stay within the same cell and not split into three cells. How can i do this?

atcodedog05
22 - Nova
22 - Nova

Hi @Savannah 

 

Just reading in will give you the data in single cell.

 

Workflow:

atcodedog05_0-1642588462019.png

 

Hope this helps : )

Savannah
8 - Asteroid

Many thanks! 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Savannah 

Cheers and have a nice day!

Savannah
8 - Asteroid

Hi!

 

Looking at my workflow, I can see that it's the Basic Table Tool that eliminates the lines in a cell and puts them all on the same line. Would you know how I can separate them into separate lines again?

 

Thanks! 

atcodedog05
22 - Nova
22 - Nova

Hi @Savannah 

 

That happens with reporting tools. Try this post.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-th...

 

Hope this helps : )

Savannah
8 - Asteroid

Perfect! Many thanks! 🙂

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Savannah 

Cheers and have a nice day!

Labels