Alteryx Designer

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

Adding Fields to my data

8 - Asteroid

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.



Alteryx Certified Partner

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

Alteryx Alumni (Retired)

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.  :smileywink: