SOLVED
Line Break in same cell in multiple columns without affecting other columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Pkumar196
6 - Meteoroid
‎05-16-2022
01:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alteryx Community
Can someone please help me to create a workflow where I can use Line Break option inside a cell on specified columns. I tried using Text to column tool selecting row in option which do separates the words in lines but creates multiple entries. I have attached my sample input and desired output.
Thank you.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
5 REPLIES 5
15 - Aurora
‎05-16-2022
01:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎05-16-2022
01:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎05-16-2022
01:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-16-2022
02:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @binuacs
Thanks for showing me multiple ways of getting my desired output. The solutions worked for me after making a minor change in the expression. The Expression I used is "Trim(Replace([_CurrentField_], ', ', CharFromInt(10)))".
‎05-16-2022
02:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @messi007 and @binuacs. Thanks for your help and provided solutions. It worked for me.
