5 Replies Latest reply: Sep 8, 2016 4:05 AM by Tom Neal RSS

    Max function not working

    Nicholas Colino

      Hello all,


      I am working with two max functions that aren't working, for the purposes of this project I am using the max to filter duplicates since I only want the latest record. I have tried to manipulate the function a number of different ways and still no luck.

       

      **The max function worked before I added the extra fields called [RC Version Date], [RC Project Name],[RC Project Number], however when a design change was brought forward I added the fields but the max functions seemed to have stopped working since my table came back with 1995 records instead of 1992, so there were 3 duplicates.


      LoadJoin:

      LOAD *

      FROM [\\ke_root.qvd] (qvd);

      Left Join

      LOAD *

      FROM [\\ke_task.qvd] (qvd);

      Left Join (LoadJoin)

      LOAD [KE Task ID],

        [RC Version Date],

        [RC Project Name],

        [RC Project Number],

        Max(Date([Last KE Task Work Info Date Q5])) as [Last KE Task Work Info Date Q5],

        Max(Date([Last KE Task Work Info Mod Date Q5])) as [Last KE Task Work Info Mod Date Q5]

      FROM

      [\\ke_task_work_info.qvd] (qvd)

      Group By [KE Task ID], [RC Version Date], [RC Project Name], [RC Project Number];

       

       

      Thanks,

      Nick