Current State:

Data Manager only allows a single attribute to be set as the primary key for an object attribute. Composite primary keys (using more than one attribute as the unique identifier) are not natively supported.

When we try to make another object attribute a primary key, we get the error below:

There is another object attribute which is set as the primary key for this object

Proposed Future State:

To have the option of configuring two primary keys for the same object.

Alternative 

Create a Concatenated Primary Key Column, for example:

• Add a computed attribute that combines ColumnA + ColumnB (e.g., ColumnA_B)
• Use this as the single primary key

This requires either:

• Pre-processing the flat file to add this column;
• Using a computed attribute in AirTrack