Help and Support > Table of Contents > Reference Definition

Define Reference


About:

The Define Reference block converts a data set into a dimension by defining the unique key for a given Object- like a product, or a customer etc. The block also resolves any duplicate key issues- allowing a single set of attributes to be assigned to each key, regardless of issues in the incoming data. For each Key (which can be one or more column) the block selects the most common value.

Define Reference Image

Block Connection Stubs
Inputs
Outputs
  • 1 The input data set that may have duplicate rows and or inconsistant data.
  • 2 A keyed data set that has unique keys with one row per key.