1 Reply Latest reply: Dec 14, 2010 4:37 PM by Kelly Korynta RSS

    Select Max in Load Statement

    Kelly Korynta

      Hello,

       

      I have a list that includes revision numbers. I'd like to 'roll up' the data in the load statement so only the current versions are selected.

       

      I thought it would be something along the lines of

      NoConcatenate Load [Special Key], max([Revision No]) as [Max Revision No], NPI
      Resident NPI
      Group By [Special Key], NPI;

      But this doesn't seem to be the case.

       

      Any idea where I'm going wrong?

       

      Thanks!