Delete duplicated data records
Summary
Depending on the defined options, this operator deletes certain duplicated data records in the input table.
Configuration
Input settings of existing table
AccessDenied
Access DeniedD22YCJ6RV9JCY51Dcc3Rm1xHYVTWVXZES5TPKTLg0sJqUliJv5TnilkyzYRzPEMtj2349yiBhB5kpCbSDhJGZgrwJRc=
Settings
AccessDenied
Access 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 |
Troubleshooting
Nothing known up to now.
Related topics
- Operators (alphabetical overview)
- Cut values
- Delete rows 2.0
- Using the Formula operator (row-by-row) (5.0) = Formeloperator Extras, it is possible to integrate a "traffic light" for certain values as a next step.