I have a column with store number, which I have setup as a string. I want to merge with "source", which is one of two letters. I can't determine the right formula to use to merge these two strings in alteryx.
Solved! Go to Solution.
Hi @MarqueeCrew ,
I've been trying those 2 formulas but I'm still having an error message. Any Idea how to fix it please?
Thanks
It could also be that one of your fields is not a string data type, you could try this formula:
ToString([LE ID]) + "|" + ToString([ASSOCIATED_LE_ID])
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan