This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!)