Start a new topic
Answered

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

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

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

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



Login to post a comment