Groovy script or Xslt xml to xml

[former_member772035]

Hi All,

I need to get latest record(Complete_Date) for each sorting field

<?xml version="1.0" encoding="UTF-8"?> <Root><Record><UserId>00091066</UserId><Required_Date>18/9/2021 Australia/Brisbane</Required_Date><Curriculum_ID>D00001 - 39523</Curriculum_ID><Complete_Date></Complete_Date><Sorting>00091066D00001 - 39523</Sorting></Record><Record><UserId>1111</UserId><Required_Date>18/9/2021 Australia/Brisbane</Required_Date><Curriculum_ID>D00001 - 39523</Curriculum_ID><Complete_Date></Complete_Date><Sorting>1111D00001 - 39523</Sorting></Record><Record><UserId>00091066</UserId><Required_Date>18/9/2021 Australia/Brisbane</Required_Date><Curriculum_ID>D00001 - 39523</Curriculum_ID><Complete_Date>10/11/2019 08:00 PM Australia/Sydney</Complete_Date><Sorting>00091066D00001 - 39523</Sorting></Record><Record><UserId>2222</UserId><Required_Date>18/9/2021 Australia/Brisbane</Required_Date><Curriculum_ID>D00001 - 12345</Curriculum_ID><Complete_Date>10/11/2021 08:00 PM Australia/Sydney</Complete_Date><Sorting>2222D00001 - 12345</Sorting></Record><Record><UserId>00091066</UserId><Required_Date>18/9/2021 Australia/Brisbane</Required_Date><Curriculum_ID>D00001 - 39523</Curriculum_ID><Complete_Date>10/11/2021 08:00 PM Australia/Sydney</Complete_Date><Sorting>00091066D00001 - 39523</Sorting></Record><Record><UserId>2222</UserId><Required_Date>18/9/2021 Australia/Brisbane</Required_Date><Curriculum_ID>D00001 - 23411</Curriculum_ID><Complete_Date>10/05/2021 08:00 PM Australia/Sydney</Complete_Date><Sorting>2222D00001 - 23411</Sorting></Record></Root>

Thank you in advance for the help.