Modifying Invalid Data

Use the data faceting function to filter out invalid data, and then modify the invalid data.

This example shows how to modify the numeric values within the range of 200 - 910, non-numeric values, and blank values in the HR column.

Procedure

  1. Click the data type icon before the HR column header, and change its data type to Integer.
  2. From the HR column menu, click Facet > Numeric facet.
    A bar chart is displayed in the HR facet panel. The heart rates of patients consist of 27 numeric values, 3 non-numeric values, and one blank cell. The heart rate ranges from 10 to 910 beats a minute.

  3. Move to restrict the range to 200.00 - 910.00.
    The rows with values within the range of 200 - 910, and the rows with non-numeric and blank HR values are displayed on the data page.
  4. Move your mouse pointer over an invalid value. Click Edit.
  5. In the "Edit this cell" dialog, enter a new value for the invalid heart rate, and then click OK.
    Continue to modify other invalid heart rate values.