Splitting Columns by Condition

Use this function to split a column based on a value of another column. Only the cell values that conform to the specified condition are split.

Take the project in the Sample-patients dataset as an example. The VISIT column provides the visit date information of each patient and the GENDER column displays the gender information of each patient.

To split the VISIT column based on the GENDER column:

Procedure

  1. From the VISIT column menu, click Edit columns > Split columns by conditions.
  2. Click Create next to Condition expression to create a condition.
  3. In the Expression field, enter cells['GENDER'].value=="F". Click OK.
    You can click History to check the previously created condition expressions and click Help to get help information regarding expression syntax.
  4. Click Separator and enter the forward slash (/) in the field next to the radio button.
  5. Click Add next to Condition layout list to add the condition you have created.
    The created condition expression and selected splitting method are displayed in the Condition layout list panel.
  6. Click OK.
    Only the female visit dates are split.