Question
Ernst & Young LLP
IN
Last activity: 12 Oct 2022 9:51 EDT
Finding latest date from multiple rows in pagelist
Hi , I have the below requirement
Pagelist ID Date(yyyymmdd)
1 20221012
1 20221011
2 20221009
2 20221008 My requirement is to fetch the latest date for every ID My final requirementis below
ID Date
1 20221012
2 20221009 Please let me know if you have any leads or suggestion. Thanks
Updated: 12 Oct 2022 5:42 EDT
Commonwealth Bank of Australia
IN
Hi @SwathiM5232,
JPMC
IN
Hi Swathi..
Just try if this works. Sort the entire page list based on ID column using Sort method in data transform with ascending order and also add Date column in same sort method with descending order.
Now iterate over the source page list and when ever ID value changes put that entry into target page list. Your target page list now has the required list.
Hope this helps.
Ernst & Young LLP
IN
@SanthoshRangaHi Santhosh... My ID property is text property with values something like ths 11022 , 19877 . It is some unqiue identifier
JPMC
IN
@SwathiM5232 Since those are just numbers. Still the approach suggested will work I suppose, because based on sorting only we are pulling the highest ID's.
Could you please give a try and let me know if it didn't worked.
JPMC
IN
@SwathiM5232 can this values be inserted into a temporary table and we can make use of group by on the Id column and max on the date column?