Data Transformation Engine Design Studio Tutorial

Chapter 4 - Using the UNIQUE Function Editing a Card
Design Studio Tutorial
113
When the data objects are expanded on the ContactFile input card and the
UniqueContactsFile output card, the cards should look like this:
In this map, you want to map only the unique contact records. Use the
UNIQUE
function, which evaluates a series of objects, belonging to some type.
The
UNIQUE function returns the unique data objects in that series. The syntax of
the
UNIQUE function is:
UNIQUE ( series_whose_unique_objects_you_want )
To enter the UNIQUE function for the Contact data object
1 Expand the objects on the output card until Contact is displayed.
2 Insert the UNIQUE function for the Contact data object on the
UniqueContactsFile output card.
UNIQUE ( ) appears in the Rule Bar.
3 Drag Contact from the input card into the Rule Bar between the parentheses.
4 Press Enter to commit the map rule.
5 Build and run the map.