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

Confluence Op Delete duplicates.gzip

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

TIS doppelte Datensätze Ampel.gif