Keeps duplicates

Supported in: Batch

Keep duplicate rows from the input.

Transform categories: Other

Declared arguments

• Column subset - If any columns are specified only those will be used when determining uniqueness.
  Set<Column<AnyType>>
• Dataset - Dataset to keep duplicate rows from.
  Table

Examples

Example 1: Base case

Argument values:

• Column subset: {tail_number}
• Dataset: ri.foundry.main.dataset.aggregate

Input:

Output:

---

Example 2: Base case

Description: No subset looks for exact duplicates. Argument values:

• Column subset: {}
• Dataset: ri.foundry.main.dataset.aggregate

Input:

Output:

---

Example 3: Null case

Argument values:

• Column subset: {tail_number}
• Dataset: ri.foundry.main.dataset.aggregate

Input:

Output:

---