Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Adding Fields to my data

mattlukoff
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.

 

Thanks!

2 REPLIES 2
roadhouse
7 - Meteor

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

RodL
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.  Smiley Wink

Labels