Extracting Change only data only if change meets specific condition(business rule)

Summary:

Hello All,

I have multiple requirements where i need to extract Assignments, Grade etc related data whenever there is a change and the change should match a predefined condition.

For example

A extract should retrieve records whenever there is change in Assignment Category to and from value "ABC"

Record 1 : Person A , Old Assignment Category : XYZ , New Assignment Category : ****

Record 2: Person B, Old Assignment Category : XYZ , New Assignment Category : ABC

Record 3: Person B, Old Assignment Category : ABC, New Assignment Category : ****

For above scenario, extract should returns Record 2 and Record 3. Record 1 should not be part of extract output.

At this point my proposed solution is to create a change only extract that will track the assignment category change irrespective of specific condition. We will later restrict the data(CSV output) in EText template based on the specific condition.