illegal combination of prefixes

Mon, 01 Dec 2014 14:42:46 GMT

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

Re: illegal combination of prefixes

simenkg — Mon, 01 Dec 2014 14:46:57 GMT

Just remove NoConcatenate.

Re: illegal combination of prefixes

rubenmarin — Mon, 01 Dec 2014 14:50:27 GMT

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.

topic Re: illegal combination of prefixes in QlikView

illegal combination of prefixes

Re: illegal combination of prefixes

Re: illegal combination of prefixes