merge two strings

[khuth2]

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. 

[MarqueeCrew · Accepted solution]

@khuth2

Try something like:

[Store Number] + '-' + [Source]

or

[Store Number] + [Source]

[MH5]

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 

[MarqueeCrew]

@MH5 ,

hint:   + "|" +

when you add a string that isn't a variable, it needs to be quoted. 

cheers,

 mark

[Jonathan-Sherman]

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