Delete duplicated data records
Summary
Depending on the defined options, this operator deletes certain duplicated data records in the input table.
Example: How many different shift types are in the data?
Situation | The following data node (excerpt) contains shifts worked by different employees, as indicated by column D "Shift_Type".
In order to investigate how many different shift types the employees have worked, we use the operation "Delete duplicated data records". |
|---|---|
Settings | The column to be checked is D containing the shift types
|
Result | The results are shown in the following data node. In total, 8 "S" shifts, 4 "N" shifts, and 2 "F" shifts have been worked in this example.
|
Project-File |
Want to learn more?
Settings
Depending on the defined options, this operator deletes certain duplicated data records in the input table.
Columns of input table
Parameter
Troubleshooting
Nothing known yet
Related topics
- Using the Formula operator (row-by-row) (4.0) = Formeloperator Extras, it is possible to integrate a "traffic light" for certain values as a next step.
