merge two strings

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.

Datasets

Best Practices

Accepted answers

MarqueeCrew

@khuth2

Try something like:

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

[Store Number] + [Source]

All comments

MarqueeCrew

@khuth2

Try something like:

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

[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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703