Calculating max date for PRODUCT in Load Script

rsdhavle — Sat, 16 Nov 2024 03:13:22 GMT

I have list of Products and some execution dates are getting generated against them link below

PROD Date

A 12/06/19

B 12/06/19

A 15/06/19

A 16/06/19

B 14/06/19

C 12/06/19

I want to calculate max date against each PROD execution at Script level so that it will show PROD and Max Data against it in Date column

How can I calculate this in Load Script?

Re: Calculating max date for PRODUCT in Load Script

jonathandienst — Fri, 21 Jun 2019 07:45:41 GMT

After loading the products and dates (into table 'Data' for example):

Left Join(Data) LOAD PROD, Max(Date) as ProductMaxDate Resident Data Group By PROD;