Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

illegal combination of prefixes

Hi

I am confused.  Annoyingly I have encountered this error message before but can not for the life of me remember what I did to solve the issue.

So when I reload the script I get the overly dramatic error message "Illegal combination of prefixes".  To get the script to load without error I remove the word in bold (mapping)???  This obviously defeats the object so could someone advise what/why this error is?

I originally had a more concise LOAD script doing the Order By in the mapping load but due debugging I split it into a separate section for clarity.

Essentially I am concatenating 2 tables (3 fields in each) - sorting them and then just reloading the sorted and complete table with only 2 fields to create the mapping table...?

tempEmpData:

LOAD

    EMPNO,

    EMPSN,

    PCPDAT

;

SQL

    SELECT

    EMPNO,

    EMPSN,

    PCPDAT

FROM

    SAAPAYDTA.PAYHISTP

;

//Concatenate(tempEmpData)

LOAD

    EMPNO,

    EMPSN,

    PCPDAT

;

SQL

    SELECT

    EMPNO,

    EMPSN,

    PCPDAT

FROM

    SAAPAYDTA.MONHISTP

;

tempEmpData_Sorted:

NoConcatenate

LOAD

    *

RESIDENT

    tempEmpData

ORDER BY

    PCPDAT DESC,

    EMPNO

;

DROP FIELD

    PCPDAT

;

DROP TABLE

    tempEmpData

;

tblmap_Test:

NoConcatenate mapping LOAD * RESIDENT tempEmpData_Sorted; // ORDER BY PCPDAT DESC, EMPNO;

DROP TABLE

    tempEmpData_Sorted

;

Many thanks

Oli

1 Solution

Accepted Solutions

Re: illegal combination of prefixes

Hi Oli, remove the "NoConcatenate" before the "mapping" and it should work.

Also, mapping table only uses firsts two fields, the first for keys to search and the second for values to return in applymap, you can rename the two fields you want to use if the problem is autoconcatenating.

View solution in original post

2 Replies
Partner
Partner

Re: illegal combination of prefixes

Just remove NoConcatenate.

Re: illegal combination of prefixes

Hi Oli, remove the "NoConcatenate" before the "mapping" and it should work.

Also, mapping table only uses firsts two fields, the first for keys to search and the second for values to return in applymap, you can rename the two fields you want to use if the problem is autoconcatenating.

View solution in original post