Modify the Primary Keys of an Event

The following script sets the primary key of the Event:

from io.hevo.api import Event

def transform(event):

    event.setPrimaryKeyFields(['<new_field_name1>','<new_field_name2>',...])

    return event

Sample Transformation

The script below demonstrates how this method can be used. It:

1. Sets the primary keys of the Event to a composite key comprising the ID and Student Name fields.

2. Retrieves the new primary keys.

3. Adds the new_pk_fields property to the Event.

from io.hevo.api import Event

def transform(event):

    # Set a field (or a list of fields) as the primary key
    event.setPrimaryKeyFields(['ID', 'Student Name'])

    properties = event.getProperties()
    properties['new_pk_fields'] = event.getPrimaryKeyFields()

    return event

Sample Output

The Transformation adds the list of primary key fields for the Event as a new property called new_pk_fields.

Revision History