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

Break a single string column to multiple rows

SGR_Altryx
5 - Atom

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

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

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

SGR_Altryx
5 - Atom

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
9 - Comet

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. 

 

.....

 

 

rfoster7_1-1571950437513.png

 

rfoster7_0-1571950349798.png

 

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

JosephSerpis
17 - Castor
17 - Castor

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
8 - Asteroid

Hi,

 

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

 

MultiSplitString_Regex.PNG

 

 

 

 

 

 

 

 

 

 

 

Thanks.

Labels