Getting the Last Record(s)

[KamenRider]

Guys,

I would like to seek for you help in getting the last records considering if it is one or more records and identical.

For example:

in this example they have identical type or entity, so I would be getting all.

In this example: 

 

There are four records and the last three are identical, so I would be getting the last 3.

In this example:

In this example, there are 8 records and the last record is V2024 with no other identical records. So only 1 record to be recorded.

Kindly help me how I am going to produce this kind of scenarios. Attaching the three sample source file for your reference.

Kamen 

[binuacs]

@KamenRider What is the expected result for the sample03 file and why?

[KamenRider]

Hi @binuacs 

V2024 is the last record. If in case V2024 has 3 records, we are still going to capture the three identical V2024 records.

Kamen

[binuacs · Accepted solution]

@KamenRider one way of doing this

[KamenRider]

Thank you so much @binuacs . You did it again.

Kamen