A court-system notable already has a CIM user field. The analyst runs a sparse HR lookup that only matches some clerks. Which lookup writing option preserves the original user on non-matches instead of wiping it?
Select an answer to reveal the explanation.
Short Explanation
OUTPUT is a bull in the china shop: miss a clerk in the HR table and it can blank the user you already had. OUTPUTNEW — or writing to a new field — leaves the notable's CIM user standing when the lookup is sparse.
Full Explanation
lookup OUTPUT overwrites named fields; when the table has no match it can clear the existing value. OUTPUTNEW writes only when the destination field is absent, so a sparse court HR lookup will not erase the notable's CIM user. Outputting to distinct field names is another safe pattern. rex after the lookup still discards the investigation key, and tstats does not restore a field the lookup just wiped.