How to create a new line(not row) in a table

[wonka1234]

hi,

Is there a way to create new line or equivalent of doing a "ENTER" in a cell in a basic table? I do not want a new ROW created. Just a new line.

Before -

City	Team
Toronto; New York	Raptors; Knicks

After - 

City	Team
Toronto; New York	Raptors; Knicks

thanks.

[PhilipMannering]

In a Formula or Multi-Field Tool. You could use the expression,

replace([_CurrentField_], '; ', ';
')

[cjaneczko]

You can use the following formula.

Replace([City], '; ', '; '+ CharFromInt(10))
Replace([Team], '; ', '; '+ CharFromInt(10))

[wonka1234]

@cjaneczko @PhilipMannering 

thanks! But this doesnt separate lines in basic table view

[cjaneczko]

For the Table Layout tool take a look at this thread. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Working-with-wanted-line-break...

The other solutions will work if you export to Excel. 

[PhilipMannering]

You're quite right. Apologies. Perhaps try this,

[binuacs]

@wonka1234 one way of doing this