Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating grouping buckets for a tab within my application. This script executes without the noconcatenate, but then the data is wrong (the groupings are multiplying the results). When I use noconcatenate, the data is correct, but I get an"illegal combination of prefixes" error, and now I'm stuck.
Here's my code:
JOIN (PL_QUOTE)
LOAD
DM_QUOTE_ID,
IF(QT_LENGTH_OF_TERM <= 6, '6m', '12m') AS POLICY_TERM_GROUPING
RESIDENT PL_QUOTE;
JOIN (PL_QUOTE_RISK_DRIVER)
NOCONCATENATE LOAD
DM_QUOTE_ID_DRIVER,
IF(DV_MINOR_CNT = '0', '0',
IF(DV_MINOR_CNT = '1', '1',
IF(DV_MINOR_CNT = '2', '2', '3+'))) AS MINOR_CNT_GROUPING,
IF(DV_ACC_CNT = '0', '0',
IF(DV_ACC_CNT = '1', '1',
IF(DV_ACC_CNT = '2', '2', '3+'))) AS ACC_CNT_GROUPING,
IF(DV_AGE_CALC >= 16 AND DV_AGE_CALC <= 20, '16-20',
IF(DV_AGE_CALC >= 21 AND DV_AGE_CALC <= 26, '21-26',
IF(DV_AGE_CALC >= 27 AND DV_AGE_CALC <= 30, '27-30',
IF(DV_AGE_CALC >= 31 AND DV_AGE_CALC <= 35, '31-35',
IF(DV_AGE_CALC >= 36 AND DV_AGE_CALC <= 40, '36-40',
IF(DV_AGE_CALC >= 41 AND DV_AGE_CALC <= 45, '41-45',
IF(DV_AGE_CALC >= 46 AND DV_AGE_CALC <= 50, '46-50',
IF(DV_AGE_CALC >= 51 AND DV_AGE_CALC <= 60, '51-60',
IF(DV_AGE_CALC >= 61 AND DV_AGE_CALC <= 75, '61-75',
'76 +'))))))))) AS AGE_GROUPING,
IF(DV_SPD_CNT = 0, '0',
IF(DV_SPD_CNT = 1, '1',
IF(DV_SPD_CNT = 2, '2',
'3+'))) AS SPEED_COUNT_GROUPING
RESIDENT PL_QUOTE_RISK_DRIVER;
JOIN (PL_QUOTE_RISK_DRIVER)
NOCONCATENATE LOAD
If you use JOIN then you can't also use NOCONCATENATE or CONCATENATE. So remove the NOCONCATENATE here.