Experts,
I have a scenario as in below tables.
Table(1) - shows the source data.
Table(2) - Shows the generated result.
But I need the result as in Table(3). Expected is : Amount based on minimum date of each ID. Tried by applying 'foreach' and 'in' but no luck.
Table(1)

Table(2)

Table(3)

Thanks in advance.