1 Reply Latest reply: Aug 5, 2014 2:37 AM by Tresesco B RSS

    How to load Max(field) in load script

    Senarath Bandara Herath

      Hi,

       

      I wanted to load Max(INVOICE_ID) as MaxID since my requirement is to get the DESCRIPTION of latest INVOICE_ID grouped by VENDOR_NAME.

      Requirement is to get latest description of the invoice vendor wise.

       

      LOAD

        INVOICE_ID,

        INVOICE_NUM,

           VENDOR_NAME,

           VENDOR_SITE_CODE,

           ADDRESS_LINE1,

           ADDRESS_LINE2,

           ADDRESS_LINE3,

           CITY,

           DESCRIPTION,

           Date(INVOICE_DATE,'DD/MM/YYYY') as INVOICE_DATE,

           Date(ACCOUNTING_DATE,'DD/MM/YYYY') as  ACCOUNTING_DATE,

       

      Many thanks,

      Senarath