Is python processing slower in Alteryx VS in-built Alteryx tool

[gelvira]

Hello everyone, 

I have a long string - I used python tool and wrote a code in python to process the string in tabular format & format every aspect as per my requirements. 

My issue is: When I pass 5000 records through this python logic in Alteryx then it's relatively fast but more than a million records is taking a long time and my flow runs for more than an hour. Is there any way I can optimize python script in Alteryx or would re-writing same logic in Alteryx help?

I appreciate any suggestion in this regard!

Thanks!

Sample: 

130=20 131=22 132=100 133=200 130=19.5 131=22.1 132=100 133=200 130=19.76 131=22.4 132=1000 133=200 130=20.1 131=22.8 132=900 133=70 175=4...…

130	131	132	133	175
20	22	100	100	4
19.5	22.1	100	200	4
19.76	22.4	1000	200	4

[BrandonB · Accepted solution]

No need to use Python, Alteryx could do this as well! 

Workflow attached

[gelvira]

@BrandonB oh wow! This looks way easier! Thanks a ton!!!!