tUniqRow example
In the following example, the tUniqRow component, labelled deduplicate_names, is configured to de-duplicate a list of names and provide two output flows, one for unique names and the other for duplicates.
setSettings {
UNIQUE_KEY {
SCHEMA_COLUMN : "id",
KEY_ATTRIBUTE : "false",
SCHEMA_COLUMN : "firstName",
KEY_ATTRIBUTE : "true",
SCHEMA_COLUMN : "lastName",
KEY_ATTRIBUTE : "true"
},
LABEL : "deduplicate_names",
}
addSchema {
NAME: "UNIQUE",
CONNECTOR: "UNIQUE"
addColumn {
NAME: "id",
TYPE: "id_Integer",
LENGTH: 3
}
addColumn {
NAME: "firstName",
TYPE: "id_String"
}
addColumn {
NAME: "lastName",
TYPE: "id_String"
}
}
addSchema {
NAME: "DUPLICATE",
CONNECTOR: "DUPLICATE"
addColumn {
NAME: "id",
TYPE: "id_Integer",
LENGTH: 3
}
addColumn {
NAME: "firstName",
TYPE: "id_String"
}
addColumn {
NAME: "lastName",
TYPE: "id_String"
}
}