Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Yes, it works
Thank you very much..