Summary

Depending on the defined options, this operator deletes certain duplicated data records in the input table.

Configuration

Input settings of existing table

AccessDeniedAccess DeniedD22YCJ6RV9JCY51Dcc3Rm1xHYVTWVXZES5TPKTLg0sJqUliJv5TnilkyzYRzPEMtj2349yiBhB5kpCbSDhJGZgrwJRc=

Settings

AccessDeniedAccess DeniedD22GMDQMPQAPP3EPipiUlyVTiIV3jDXVfNxcwNN7BDMBPA9Kx8olMC/J0eYdX5tm8Jr597vaEN3ShSEALE/UCD8O+pk=

Want to learn more?

Examples

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


Troubleshooting

Nothing known up to now.

Related topics