Alteryx Designer Desktop Discussions

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

I'm using the formula tool to try to make a new column that adds "R" + [RecordID] = R1, however it's not allowing me.

1 REPLY 1

If RecordID is a numeric data type, you have to convert it to a string. Try

"R" + ToString([RecordID],0)

Chris

Combine letters and numbers to make a Unique Identifier