Splitting Columns and Reordering

Use this function to split a column and reorder the split columns.

Take project 1 in the Sample-patients dataset for example.

The VISIT column provides the visit date information mostly in the mm/dd/yyyy format. There is one exception, 15/12/1999 ( patient number is 123 in the PATNO column), which is in the dd/mm/yyyy format. When splitting this cell, you need to reorder the split columns. To split the VISIT column into Month, Day, and Year columns, and reorder the split columns:

Procedure

  1. From the VISIT column menu, click Edit columns > Split columns and reorder.
    The Split column by condition with reorder on column VISIT dialog is displayed.
  2. In the Target column name field, specify the names for the spilt columns one by one. Here, enter Month for the Month column, and then click Add. Add the names for the Day and Year columns one by one.
  3. Click Create next to Condition expression to create a condition.
    The Preview condition expression dialog is displayed.
  4. In the Expression field, enter cells['PATNO'].value=="123". Click OK.
  5. Click Separator and enter the forward slash (/) in the field next to the radio button.
  6. Click Add next to Condition layout list to add the condition.
  7. Click Reorder.
  8. In the Reorder Columns dialog, drag the split columns to map the date format. Click OK.
Contents
Search Results