Splitting a Column

After transforming a column with inconsistent date formats, you can split it into several columns.

Prerequisites

Transforming Date Formats

This example shows how to split the transformed DOB column to create a month column.

Procedure

  1. From the DOB column menu, click Edit column > Split into several columns.
  2. In the Separator field, enter /, and then click OK.
    Three columns, DOB 1, DOB 2, and DOB 3 are created that display the day, month, and year data.
  3. Remove the DOB 1 and DOB 3 columns:
    1. From the DOB 1 column menu, click Edit column > Remove this column.
    2. From the DOB 3 column menu, click Edit column > Remove this column.
  4. Rename the DOB 2 column. Double click the column name DOB 2, and then enter Month.