Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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