//REAL
ACTIONID RATE
FX1 1.12
FX2 1.13
FX3 1.5
//INPUT
ACTIONID PREVIOUSACTIONID AMOUNT
FX1 NULL 100
FX2 FX1 200
FX3 FX2 300
//EXPECTED
ACTIONID RATE FLAG VARIANCE
FX1 CURRENT NO YES
FX2 PREVIOUS YES MAYBE
FX3 1.9 YES YES
//OUTPUT SHOULD BE Following
if RATE is 'CURRENT' then Pick the Rate from REAL
if RATE is 'PREVIOUS' then pick the previos ActionID (FROM INPUT) rate from REAL
else RATE is from EXPECTED, And all other field of EXPECTED Should also be retrieved.
ACTIONID RATE FLAG VARIANCE
FX1 1.12 NO YES
FX2 1.12 YES MAYBE
FX3 1.9 YES YES