Adding Fields to my data

[mattlukoff]

Hi, can anyone direct me with regard to how I can add fields (including the content of those fields) in my data set. The field and content would be static. It's for mapping purposes. I.e. assuming data file 1 has a field called 'Color' and data file 2 does not. I want to use Alteryx to add a field called 'Color' with content of "Blue" in data file #2.

Thanks!

[roadhouse · Accepted solution]

You can do this with the Expression tool. Just create a new row with your static value in the expression.

[RodL]

To be accurate in case others look at this response, the tool is actually the Formula tool. It has an Expression window in it where you write the formula/expression for the new field.