Highlight Duplicate Data in Sorted Datawindow
Posted on 2006-06-26
We have a data cleansing project going on.
I would like to create a datawindows that retrieves data either from a database or import the data from a spreadsheet.
I would like to create a computed field to check on the value of one field (employee ID) to see if it is a duplicate.
I plan to sort the datawindow by employee id.
In the computed field or in the backcolor property for employee id, I would like to enter an expression that checks to see if the value of the field in the previous row or the next row is the same.
I don't really know how to refer to another row in a datawindow expression.
So I was thinking that it could be something like:
if(emp_id = (getrow + 1(emp_id)), rgb(0,0,0),rgb(255,255,255))
What I don't know is how to get the value of emp_id from the next row down.
Can anyone help here. I would prefer not to have to write a function for this as the datawindows will be throw aways.