Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

merge two strings

khuth2
5 - Atom

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. 

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@khuth2

 

Try something like:

 

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

or

 

[Store Number] + [Source]
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MH5
6 - Meteoroid

Hi @MarqueeCrew , 

 

I've been trying those 2 formulas but I'm still having an error message. Any Idea how to fix it please? 

MH5_0-1581500412667.png

 

MH5_1-1581500428799.png

 

Thanks 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@MH5 ,

 

hint:   + "|" +

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

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Jonathan-Sherman
15 - Aurora
15 - Aurora

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

 

Labels