Job Runner

Combine Records

Overview

Create a new list of records that connects the lists of record #1 and record #2.

Usage

You need to import the records you wish to deduplicate before you can use this Do. Use Dos such as “Retrieve All records” or “Retrieve Records by Providing Key” to do this.

The combined results from Combine Records can be used in another action as a result of the action that installed this To Do.

You can connect the Combine Records action to the next action when one Source Record row is ready to perform the action line by line on all records.

If you want to process the combined records together, connect when all Source Record rows are ready or when other actions are completed. If connected with When All record Rows Are Ready, it will not execute if both Records #1, #2 are empty. record is also executed when other actions are completed.

The join simply connects the record List of “Record #2” to the record List of “Record #1”. If both Record #1 and Record #2 contain the same record, the combined record will contain two of those records. If you want to eliminate such duplicates, use Remove Duplicated Records after merging.

The underlying Record #1 and Record #2 remain unchanged by this action.

Parameters

Set Record #1 and Record #2.

Record

Specifies the first record that you want to merge. After combining, this will be in the foreground.

Record

Specify the second record you want to merge. After joining, this will follow.

Occurrence of record Retrieval Criteria

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

If both Record #1 and Record #2 are empty and there are no records, neither occurs.

Restrictions

  • Record #1 and Record #2 must be records from the same app.