Support DESK

Follow

Appendix A - Configuration Guide - Column Types

Previous Article matchIT Hub Index Next Article 

The following column types can be used when defining the input data columns. Refer to Data Settings, above, for further details including how to map multiple elements by prefixing with "First", "Second", "Third", "Fourth" and "Fifth".

Unique Ref

  • UniqueRef.

A unique ref is typically mapped to a table's primary key column, if available. For certain operations, such as when calling the engine's GetData() method, a unique ref is required and must therefore be mapped to the input data.

Name

  • FullName;
  • Prefix;
  • FirstNames;
  • Forenames - synonym of FirstNames;
  • MiddleNames;
  • Initials;
  • LastName;
  • Surname - synonym of LastName;
  • Qualifications;
  • Suffix.

For best results specify either FullName or a combination of the other fields (Prefix, FirstNames, MiddleNames, Initials, LastName, Qualifications, and Suffix). If FullName is specified then the name elements will be extracted (and can be output when the engine is configured for normalization mode).

Organization

  • Organization;
  • Company - synonym for Organization;
  • Department;
  • JobTitle.

Address

  • Address1;
  • ...
  • Address9;
  • Town;
  • City - synonym for Town;
  • Region;
  • State - synonym for Region;
  • County - synonym for Region;
  • Postcode;
  • ZIP - synonym for Postcode;
  • ZipPlus4 - synonym for Postcode; (From version 2.0.3)
  • PostOut;
  • Zip5 - synonym for PostOut; (From version 2.0.3)
  • PostIn;
  • Plus4 - synonym for PostIn;
  • DeliveryPoint;
  • DPS - synonym for DeliveryPoint;
  • Country.

Telephone

  • Telephone;
  • Fax.

Email

  • Email.

Date of Birth

  • DateOfBirth;
  • DOB - synonym for DateOfBirth.

Website

  • Website;

Custom Fields

  • CustomField1;
  • ...
  • CustomField9.

Other

  • Other;
  • Other1;
  • ...
  • Other32; (before version 2.0.3)
  • Other200. (from version 2.0.3)

Other-type columns cause data in that column to be ignored. This can be useful when outputting a copy of the input data (matching mode) or for passing unmodified data straight into the output (normalization mode).

Previous Article matchIT Hub Index Next Article 
Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.