Validating Data

Use the data validation function to filter out invalid data.

1. On the toolbar, click Validate.
2. Next to Data types and constraints, click Auto suggest.
3. In the "Configure data type" dialog, keep the default settings, click Next.
4. On the "Data type result" page, use the data types suggested by TIBCO Clarity, click Next.
5. Configure the constraints for the Gender column data type:
   1. From the third field, select Valid list.
   2. Click Click to add/edit valid list.
   3. In the Enter a valid value field, enter M, and then click Add.
   4. In the Enter a valid value field, enter F, and then click Add.
   5. Click Save.
6. Click Save changes to start validating data.
   The validating results are displayed on the data page. The rows that contain invalid values are marked with the icon.
7. Click an invalid icon to view the details. For example, click the invalid icon before the number 4 row, and then it shows: String value doesn't match expression. Click the invalid icon before the number 17 row, and then it shows: String value is not valid.