How to load Max(field) in load script

[senarath]

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

[tresesco · Accepted solution]

Do it in the from end, like:

Chart: Straight table

Dimension: VENDOR_NAME

Expression: =FirstSortedValue(DESCRIPTION, - INVOICE_ID)              // Note, '-' sign