Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Getting an "illegal combination of prefixes" error when using a noconcatenate load.

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;

1 Reply
MVP & Luminary
MVP & Luminary

Re: Getting an "illegal combination of prefixes" error when using a noconcatenate load.

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.


talk is cheap, supply exceeds demand