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?
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.