Data Files validation based on the Date range.

Hello Team,

I am looking for a solution to address the following scenario and would appreciate your kind support.

*

Page 1 contains rows with unique IDs and their corresponding Start Date and End Date (each unique ID appears only once).

*

Page 2 contains the same unique IDs, but each ID is split into multiple rows based on different Date values.

Example:

*

On Page 1, a unique ID (say ID = 1) has the following range:

Start Date: 01/08/2025

*

End Date: 01/10/2025

On Page 2, the same unique ID appears as:

*

Row 1: 01/08/2025

*

Row 2: 20/09/2025

*

Row 3: *01/10/2025

Regards*

*

Madhusudhan j