5 Replies Latest reply: Dec 22, 2017 5:19 PM by Rob Wunderlich RSS

    Autonumber not working ?

    Steven Stocki

      Blown away at what I am doing wrong.

       

      Trying to get an "AutoNumber" for Name and SpecialtyDMis.. but yet it acts as if the SpecialtyDMis doesn't exist ?

       

      Any ideas? Thanks

       

      Example fake data below.

       

      [SurgeonUpdate3]:

      load*,

      Autonumber(Name2,SpecialtyDMis) as [HighestDMisSpecialty]

      Resident [SurgeonUpdate2]

      Order by Name2,Count Desc;

      Drop table [SurgeonUpdate2];

      QlikError.jpg