Open topic with navigation

Add Dedup Table

Modules>Admin>Dedup Table>Add Table

Add a Dedup Table to control how data in custom tables is handled during the Combine and Merge Duplicate Records process.

To add a Dedup Table, use the following steps:

1. Go to Modules>Admin>Dedup Table>Add Table. The Add - Dedup Table page opens.
2. Use the descriptions in the table below to enter information:

   Field Name	Required	Description
   file group	Required	Select the file group in which the table will be stored.
   table name	Required	Select the table name.
   customer	Required	Select the customer key name.
   update order	Optional	Enter the order in which this table should be processed.
   sql before merge	Optional	Enter any SQL commands or stored procedures to run immediately before the combine/merge process.
   sql after merge	Optional	Enter any SQL commands or stored procedures to run immediately after the combine/merge process.

3. Click Save to save the new Dedup Table and go to the Admin module Overview page. Click Cancel to go to the Admin module Overview page without saving your changes.