Line Break within a cell using Condition

Question

Hi Team,

I have a column named Data in which the each row value differs by length. And there is no standard length for the row values.

My concern is whenever the length of row value exceeds 26 I need the values in the row to be breaked into next line in the same row. For example if my length of the row is 52, then I need a row with 26 values at the top and 26 characters at the same row in the next line.

If my length of the row is 78, then I need 3 lines splitted as 26 characters each in a single row.

Can anyoune help me on this.

Have attached the sample input & output data

Sample Data.xlsx

flying008 · Answer

Hi, @Gsiva3

FYI.

Input Data 11111111,22222222,33333333 11111111,22222222,33333333,44444444,55555555,66666666 11111111,22222222,33333333,44444444,55555555,66666666,77777777,88888888,99999999 12345678 12345678,87654321     OutputRecordIDData111111111,22222222,33333333211111111,22222222,33333333, 44444444,55555555,66666666311111111,22222222,33333333, 44444444,55555555,66666666, 77777777,88888888,99999999412345678512345678,87654321

Gawa · Answer

@Gsiva3

You can refer to this thread for rendering table with multiple lines.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-Render-a-Table-with-Multiple-Lines-in-a-Cell/td-p/775643

caltang · Answer

Try this:

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

For Gsiva3.yxmd