Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rubenmarin

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
simenkg
Specialist
Specialist

Just remove NoConcatenate.

rubenmarin

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.