How to configure data

Question

Hey Alteryx community, simple question but I'm trying to use the formula tool to add some text to a column of data. The column of data are all 6 digit numbers and all I want to do is add a "C" in front of all the numbers; i.e. C123456, C234567, etc.

There has to be a simple way to do this, I'm also open to other forms.

Jay-RDC · Answer

Hello. You can just type ""

CMCesar · Answer

Thanks Michelle!

Another question, within the formula tool. If I wanted to add a column and have the column blank do I need to type in "null" ?

michelle_mathews · Answer

@CMCesar , use the Select tool to ensure your column of data is a string field then you can use the formula: "C"+[Data Field]