How to load Max(field) in load script

senarath — Tue, 05 Aug 2014 06:26:29 GMT

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

Re: How to load Max(field) in load script

tresB — Tue, 05 Aug 2014 06:35:20 GMT

Do it in the from end, like:

Chart: Straight table

Dimension: VENDOR_NAME

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