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 would like to update values at particular column if it match to certain conditons, however it prompt a message ' Illegal combination of prefixes' after reload.

First time , i load the source to Qlikview, Then, i load the table from memory and try to using mapping load to repalce the value; However, it prompt an error message 'Illegal combination of prefixes'

TableA_temp:

NoConcatenate

load *

Resident TableA;

Concatenate

mapping load ControlDepartment,ControlDepartment1 from RemameValues;

DROP Table TableA;

How can i achieve of it? or using if statment ? Pls kindly advise

Mic

2 Replies
swuehl
MVP
MVP

You need to load your mapping table first:

MapTable:

mapping load

ControlDepartment,

ControlDepartment1

from RemameValues;

Map ControlDepartment using MapTable;

TableA_temp:

NoConcatenate

load *

Resident TableA;

DROP Table TableA;

Not applicable
Author

Yes, it works

Thank you very much..