Job Runner

Remove Duplicated Records

Overview

Remove any duplicates with the specified key value from the records, leaving only the non-duplicates.

Usage

You need to retrieve the records you wish to remove duplicates before you can use this Do. Use Dos such as Retrieve All records or Retrieve Records by Providing Key.

If there are duplicate records, the one that comes lower in the order will be deleted.

Parameter

Set Record Action and Key Field.

Record

Select the Action you used to retreive the target records.

You cannot select the Action you are currently using.

Key Field

Select the fields to find duplicates in the records.

For example, if you select a field labelled “Prefecture” and the Do finds at least two records with the same value in this field, the Do will remove the second record as well as any subsequent records with the same value in that field.

You can select multiple fields. If you select multiple fields, the Do will deduplicate if it finds multiple records with identical values in all of the specified fields.

This parameter accepts the following field types:

  • Text
  • Number
  • Calculated
  • Radio button
  • Drop-down
  • Link
  • Date
  • Time
  • Date and time
  • Lookup (string)
  • Lookup (number)

Occurrence of record Retrieval Criteria

Criteria Occurrence
“When record Row Is Ready”
“When All record Rows Are Ready”

関連記事