Hierarchical Lists

Hierarchical Lists

listclean can clean hierarchical lists, such as Accounts with Contacts with a cleansing pass required for each level in the hierarchy.

Hierarchical lists, such as Accounts with Contacts require two passes to clean the list:

  • on the first pass duplicate accounts are detected and merged
  • on the second pass the duplicate contacts are detected and merged into the cleansed accounts

Specification of the hierarchical data

Although a list of Accounts with Contacts is hierarchical, you still upload a flat spreadsheet:

listclean-ViewOriginalData

You define the hierarchical data structure contained in the data once the spreadsheet is uploaded. — Read More

listclean will make informed guesses for the hierarchical structure based on the field names, i.e. Column Headers in row 1 of the spreadsheet.