Handling records with missing values

If the majority of missing values are concentrated in a small number of records, you can just exclude those records. For example, a bank usually keeps detailed and complete records on its loan customers.

If, however, the bank is less restrictive in approving loans for its own staff members, data gathered for staff loans is likely to have several blank fields. In such a case, there are two options for handling these missing values:

• You can use a Select node to remove the staff records
• If the data set is large, you can discard all the records with blanks by following instructions in Select node