You have a data set with two different date fields (columns). Your analysis requires you to create a new field which is the number of calendar days elapsed between these two dates. Which node will…

Question

Options

• AFilter node
• BType node
• CDerive node
• DReclassify node

• A
  2% (1)
• B
  4% (2)
• C
  91% (43)
• D
  2% (1)

Explanation

Derive is the correct choice because it is specifically designed to create new fields by applying expressions or calculations to existing ones - in this case, computing the difference (in days) between two date columns and storing the result as a new field.

Filter (A) is wrong because it removes or selects rows or columns; it does not create new calculated fields. Type (B) only defines metadata about fields (data type, role, measurement level) - it reads existing fields, not creates new ones. Reclassify (D) maps existing values to new categories within a field, which is useful for bucketing or recoding, but not for arithmetic date calculations.

Memory tip: Think of "Derive" like algebra - you're deriving a new value from existing ones. Any time a question asks you to create a new field using a formula or calculation, Derive is your answer.

No community discussion yet for this question.