Data Engineering - Select Duplicate Records or Encode Duplicate Records

435
0
09-13-2022 01:07 PM
Status: Open
feralcatcolonist_old
Occasional Contributor II

Within the Data Engineering Pane, it would be great if the duplicate/unique field had enhanced functionality to either select the duplicates (as you can select other values of interest in the other fields) or to encode a value of 0/1 to identify a duplicate entry through the creation of a new field.

feralcatcolonist_0-1663099321811.png

Encode field is less useful for this task as it creates a field per unique entry; instead, there could be a binary option (0 == unique, 1 == duplicate).

Examples of similar workflows:

feralcatcolonist_5-1663099552289.png

feralcatcolonist_2-1663099489138.png

feralcatcolonist_4-1663099519091.png 

feralcatcolonist_6-1663099584298.png

 

 

 

 

Tags (1)