Removing Invalid Data

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

Suppose the normal heart rate of patients ranges from 10 to 200 beats a minute, and any value beyond this range is considered as invalid data. This example shows how to remove the values within the range of 200 - 910 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 1 blank cell. The heart rate ranges from 10 to 910 beats a minute.

  3. Move to restrict the range to 200.00 - 910.00.
    All the rows with values ranging from 200 to 910 are displayed on the data page.
  4. Clear the Non-numeric check box.
  5. Clear the Blank check box.
  6. From the HR column menu, click Edit cells > Common transforms > Blank out cells.
  7. In the HR facet panel, click Reset.

Result

All values within the range of 200 - 910 in the HR column are removed.