Merging Records

You can merge two records within a table in TIGA. This is useful when you have mistakenly added two records that represent the same information, e.g. two contacts for the same person. Using this tool, you will be able to resolve conflicts and consolidate both records.

Important

TIGA will delete data you do not include in the merged record.

The Merge Window

Once you invoke the functionality, the Merge window will pop up. In this window you select the primary (or final) record and a secondary (or duplicate) record. The window will show you the data in both records and enables you to easily update the primary record.

Merge Window

Merge Window

Description of the drop-down, tab, and button

Number

Name of the drop-down, tab, or button

Description

Left Drop-down

The primary record that will be kept after merging.

Right Drop-down

The record you want to merge into the primary record.

Self tab

Displays all fields in the record except those linked to other records.

To one tab

Displays all fields with To One relation.

To Many tab

Displays all related records from the related tables section.

Left-arrow button

Copies the data from the right to the left, the primary record.

Undo button

Reverses any changes done on the primary record (on the left).

Tip

Select the record that has the most accurate data as your primary record. Doing so will minimize the actions that need to be done thereafter.

The following tutorial shows how to merge two contacts in the Contacts table.

To merge two contacts:

  1. Open Contacts table in TIGA.

  2. Hold the Ctrl key and select the two records you want to merge.

    Tip

    Filter the table to display the records on one page.

  3. On the Record menu, click Merge. The Self tab will open by default.

  4. Select the record you want to keep after merging from the left drop-down.

  5. Select the other record from the right drop-down.

  6. Use the Left-Arrow LeftArrowButton button to copy and paste the data or Undo UndoButton button to cancel copying.

    Tip

    The Left-Arrow and Undo buttons at the top will copy all the data or reset all the changes you have made.

  7. You can modify the information in the left drop-down by typing in a field or choosing a different option from a drop-down.

  8. Continue modifying information in the To One and To Many tabs.

  9. Select Merge.

    Important

    Complete all required fields shown with the * symbol and unlink related tables in the To Many tab not merged to the primary record; otherwise, an error message will appear.

Post Condition:

You can find the merged contact in the Contacts table. Currently, the secondary record that you left will be deleted from TIGA. Make sure to review the changes before merging the contacts.

Contacts Table

Contacts Table

Watch the following merging records video.