Break a single string column to multiple rows

[SGR_Altryx]

I have a single string column with value sample as "abcdefghijklmnop", i need this value to be split into multiple rows with each row contains 5 letters.

Expecting Output;

Result:

abcde

fghij

klmno

p

Tried using generate rows but couldn't find the solve

[JosephSerpis]

Hi @SGR_Altryx I mocked up a solution that produces your output. Let me know what you think?

[SGR_Altryx]

Thanks for the solution.

But,

Data Volume for which i have to implement is very huge. I have 4 million line item with each row value

having on a average of 8000 characters.

why is that using Generate Row tool cannot be used in this case? 

[rfoster7]

you should be able to do it with just the tokenize tool then (the first tool in the proffered workflow) Just put five dots in the Regular Expression field. 

.....

You are going to end up with several billion rows though based on your set size. 

[JosephSerpis]

Hi @SGR_Altryx I came up with a second method of producing your output using the generate rows tool. Let me know what you think?

[ganesamurthy · Accepted solution]

Hi,

I am attaching my solution to this problem. Hope it helps.

Thanks.