EXCEL CELL into Drools
by Gopu.Shrestha@wellsfargo.com
I want to convert this format in Drools, how can I do this?
Excel sheet format
rule# CONDITION VARIABLES/FIELD
345 IF M_DATE less than T_M_C_1107_DATE AND
FACE_CODE eq 'C' AND
TEMP_PRODUCT_TYPE IN 'LARM', 'SARM' AND
PROG_DR_INDICATOR eq 'Y'
PROG_FN_INDICATOR eq 'Y'
THEN MESSAGE_15_FLAG = 'YES'
MESSAGE_101_FLAG = 'YES'
EXPECTED..............
Rule name " 345"
When
M_DATE less than T_M_C_1107_DATE AND
FACE_CODE eq 'C' AND
TEMP_PRODUCT_TYPE IN 'LARM', 'SARM' AND
PROG_DR_INDICATOR eq 'Y'
PROG_FN_INDICATOR eq 'Y'
Then
MESSAGE_15_FLAG = 'YES'
MESSAGE_101_FLAG = 'YES'
End
9 years, 10 months