2 Replies Latest reply: Jun 6, 2013 6:59 AM by michael.kwok RSS

    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