Formula tool: avoid concatenating values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey everyone!
I'm running into an issue with a field of initials in Alteryx.
I'm using the Formula tool to add "+@mail.com" to create email addresses, which I then use with the Email tool.
he same setup works perfectly for multiple flows, but for some reason, in one of the flows, the Formula tool produces concatenated field with initials. Instead of creating a row with individual email, the output looks something like this: "abc,adb,aad,adb@mail.com".
I'm not sure what's causing this issue, and I'm unable to replicate it in other flows.
Unfortunately, I'm unable to post a screenshot of my actual data.
Any ideas on why the Formula tool is concatenating the initials in this particular flow?
If anyone has a fix or additional tools to prevent the concatenation, it would be greatly appreciated.
I can also attach a flow that works as expected to help with troubleshooting.
Thanks in advance for your help!
- Labels:
- Tips and Tricks
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Maggie_yo if you're using a formula tool, then it takes each row in isolation so there's no way the concatenation will be happening in that formula. Check that you're using the correct field in your formula, and also check that the field doesn't contain pre-concatenated initials.
If it does, you can simply use a text to columns to split out each initial onto its own row based on the comma (like in the screenshot below)
Hope that helps,
Ollie
