Remapping a column
If you want to use a column that contains strings in an analysis, you must remap the strings to numbers. For example, Figure 6‑9 shows the strings in the Occupation column on the left and the numbers in the remapped Occupation column on the right.
Figure 6‑9 Occupation column (left) and remapped Occupation column (right)
How to remap a column
1 In Analytics—Advanced, choose PreprocessingRemap Column.
2 Drag the column you want to remap from My Data and drop it in Column in Remap column, shown in Figure 6‑10.
3 In New column, type the name of the new column.
4 Choose Create. The column appears in My Data.
Figure 6‑10 Remapping a column