Survivorship rule: change golden record status attribute to INACTIVE when all master records have the same status. : Portal

Start a new topic

Answered

Survivorship rule: change golden record status attribute to INACTIVE when all master records have the same status.

Cédric BLANC

started a topic about 4 years ago

I currently have a Survivorship rule where the golden record status field is equal to the most recent update of a master record status field. I want to change this to a Survivorship rule where the golden record status field should be changed to 'inactive' only when ALL master records have inactive statuses. If one master record becomes active, the golden record is active. Can you help with this?

Best Answer

Cédric BLANC said about 4 years ago

What you can do is to set your Status attribute value using a Post-consolidation only enricher.

Set the expression using this SemQL :

CASE WHEN ALL IntegrationMasterRecords HAVE (Status = 'INACTIVE' )
  THEN 'INACTIVE'
ELSE
  'ACTIVE'
END

1 Comment

Cédric BLANC

said about 4 years ago

Answer

What you can do is to set your Status attribute value using a Post-consolidation only enricher.

Set the expression using this SemQL :

CASE WHEN ALL IntegrationMasterRecords HAVE (Status = 'INACTIVE' )
  THEN 'INACTIVE'
ELSE
  'ACTIVE'
END