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.
I have one input to summarise tool where column has 20 email ids. I am concatenating all the email with , separator. When I am using that concatenated column in email tool, the email tool sends the email to ids present in first 255 characters. Rest is truncated.
I am looking to split the string to multiple strings each less than the length of 255 characters. But all the email ids to be included and should be complete.
I approached this by splitting the email addresses back in to individual rows, then using a series of multi-row formulas to "group" the emails back together based on the sum of their length. Finally a quick summarize to concat the emails back in to single cells (but multiple rows).
In my opinion, the better solution would be to create an active directory distro list and where Alteryx only has to ever point to one email address. If that's not feasible, here's a possible solution for you to consider. Note that I tested this to limit to 50 characters, which is defined in the first Multi-Row formula tool.
@jrgo Creating Active directory can't be a solution as that requires organization level involvement but I am using this tool for team based notification management through alteryx. Thanks for your workflow. It worked like a charm.
please do reconsider marking all possible solutions as accepted. Surely the commentary about why one is preferred is helpful. A robust set of possible solutions may help future readers. We want to encourage members to participate and to share.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.