Making a calculated column from a string to a integer
In my data set I need to make a indicator column, I am trying to do this thorugh the add calculated column and when I make the column it comes out as a string. I know its doing this becasue the column that I am using is a string. What I want, is to make a column that goes from 'AC' to '1' for example. Do you have any suggestions?