Splitting a Column

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

This example shows how to split the transformed DOB column (see Transforming Date Formats), and create a month column.

Procedure

  1. From the DOB column menu, click Edit column > Split into several columns.
    The Split column DOB into several columns dialog is displayed.
  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.
Contents
Search Results