Solved! Go to Solution.
Hey @TarunDeep
This is a fun little challenge!
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).
Which gives an output like this:
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.
@LordNeilLord & @OllieClarke Thanks for the reply. Your solutions also worked but marking this as this is the shortest.
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.
cheers,
mark
Oh, sure. In that case all 3 worked. I've marked them as solution.