You have a data set with numeric fields (columns) that contain null values. You want to replace each of these null values with the value of zero. Which node will you use to accomplish this task?

Question

Options

• AType node
• BFiller node
• CFilter node
• DBinning node

• A
  2% (1)
• B
  2% (1)
• C
  95% (41)

Explanation

There appears to be an error in the provided answer key. The correct answer should be B (Filler node), not C.

Why B (Filler node) is correct: The Filler node is specifically designed to replace field values, including null/missing values, with a specified replacement value such as zero. It lets you target fields matching certain conditions (e.g., @NULL) and substitute them with a constant or expression.

Why the others are wrong:

• A (Type node): Defines metadata about fields - data type, role, allowed values - but does not transform or replace actual data values.
• C (Filter node): Includes, excludes, or renames fields/columns in the data stream. It controls which columns pass through, not their content.
• D (Binning node): Converts continuous numeric values into categorical bins or ranges - a discretization operation, not null replacement.

Memory tip: Think "Filler" literally - you're filling in the blanks (nulls) with a value like zero. If a column has holes, the Filler node plugs them.

Note for exam takers: If your exam marks C (Filter) as correct, it may be a typo or error in your study material. In IBM SPSS Modeler (the most common context for this question), the Filler node is the established tool for null-value replacement.

No community discussion yet for this question.