5 Replies Latest reply: Oct 20, 2016 12:06 PM by Sunny Talwar RSS

    Max Value in Load Script

    mark pratt

      I need to load the following with the Max EOD value for each Tax ID, help please:

       

      LOAD

        "Tax_ID_Number" as "Tax ID",

          "EOD";

      SQL SELECT "Tax_ID_Number",

          "EOD"

      FROM "data".dbo."Source";

       

       

      Thanks in advance!