Duplicate Employee Rows Challenge

building reports webintelligence
1

We have a list of employee report and notice that some of the employees are appearing more than once. Is there a way in BO to identify only those employee who are appearing more than once in the list.

rskusa26 (BOB member since 2006-09-05)

2

you could set up a count using the count() function, place that on the grid, then set up a filter where the count item is greater than 1.

jsanzone :us: (BOB member since 2006-09-12)

3

Sure.

Sort the Emploee ID Numbers in ascending order.

Then insert a column and create the following formula:

 =If Previous(<Emp#>)=<Emp#> Then "Duplicate" Else ""

Now you should see the word “Duplicate” next to each instance where the Emp# is repeated.

andrewp :us: (BOB member since 2009-03-17)

4

Thanks very much for your quick response. I was able to identify the duplicate employee. Now the challenge is how do I show all the records of such employees?

rskusa26 (BOB member since 2006-09-05)

5

rskusa26:

working off of a_parks’ code:

Then insert a column and create the following formula: 
Code: 
=If Previous(<Emp#>)=<Emp#> Then "Duplicate" Else ""

instead of inserting a column, take the formula and build a local variable. Once the local variable is built, then left-clck once on the outer edge of your grid, then click on the “Filter” icon which opens up the Filter panel (plz don’t confuse this with the “Drill Filters” – another subject). Once the Filter panel is open, drag your new variable into the panel and receive a dialogue box which you can use to identify those rows with “Duplicate”. This should work in helping you to see the rows you want.

Thanks,
John

jsanzone :us: (BOB member since 2006-09-12)