Hi. Check out the LAG function. You can find details on it in the Help, or online explanations such as this.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------
Original Message:
Sent: Fri March 10, 2023 08:10 AM
From: Renee Damstra
Subject: How to find duplicate in adjacent field
How can I find a duplicate only for adjacent fields? So to see if there are rows with value '1' for instance after a row of value '1'?
------------------------------
Renee Damstra
------------------------------