Formula tool: avoid concatenating values

[Maggie_yo]

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.

The 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 emails:

abc@mail.com

adb@mail.com

aad@mail.com

adb@mail.com

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!

[alexnajm]

We already answered this on your previous thread!