Hi all, I am rather new to Alteryx and would like to seek help on this problem.
I have a column of comma-separated strings - some of which are really long. My objective is to parse them through an API that has a character limit. Hence, I need to break the comma-separated string into multiple rows with max. character limit.
Moreover, I would like to retain the whole word. Some of the methods I've tried would cut the word harshly while fitting into the character limit.
I'm thinking this might require a multi-row formula. However, really not sure how I can do it. Would appreciate any help! 🙂
(I've also attached a snippet of the actual data I'm trying to work on, as a csv format. Note, it is in tamil language with encoding of utf-8 that would work!)
Solved! Go to Solution.
hi @atcodedog05
Yes, the idea I have is also splitting by comma. Technically, each 'token' you see encapsulated within commas, is a single word in tamil.
Hi @alpro-23
You can text to column to split on comma to rows. Refer below snaphot.
Workflow:
Hope this helps : )
@atcodedog05 Why not to split it with your method:
With this there would be much less requests to API.
@alpro-23 Strange because for me results looks the same.
But ofcouse other methods of "inteligent" spliting are better.
Good luck
Thanks everyone for your help! I've successfully overcome the problem by integrating all your suggestions.
Happy to help : ) @alpro-23
Cheers and have a nice day!