Creating dummy variables

rajeshmr06

How can I easily create dummy variables for a given Field?

For example, let's say a Field Category has the unique values of x,y and z. I want to create dummy_x, dummy_y and dummy_z with values of 1 or 0 based on the Category field. Now, I have more than 3 unique values and it is difficult to create the dummy variables one by one. 

Is there a way to dynamically create the dummy variables based on the values of a particular field?

jdunkerley79

Yes you can create dummy for each.

The easiest way I can think of is to use a transpose to put all the fields you want to create as rows.

You can then use a formula tool to make a dummy column name.

Then use a cross tab to make it column based.

After this you can use a MultiField formula tool to fill in the nulls.

Sample attached

Make Dummys.yxmd