Hide the record with lower extractdate for a given srccode , region, material combination

[parul_mehta]

In the below data

There are currently 7 records

I want to hide the record with the lower extract date , for a given Material / srcsyscd, region combination

For example, from the first two records that belong to PKS-NSP , USA and CMC11, I want to hide the first row with the date 22/06/2017

and display only the row with the higher extract date 01072017

[devarasu07]

Hi,

Can you share your sample app, Thanks

also you may try like below 3 methods

1) max(extractdate) as your expression

2) Aggr(max(extractdate),Material,srcsyscd, region)

3) =FirstSortedValue(srcsyscd, -extractdate)

4) back end script method,

like below,

Load *,

     Date(Max(extractdate),'mm/dd/yyyy') as Date

FROM FileName

GROUP BY Material,srcsyscd, region;

Hope this helps to you

Thanks,

Deva