You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help with Duplicate Rows in Candidate Regulations Field

Received Response
49
Views
4
Comments
edited Oct 31, 2016 3:08PM in Reporting and Analytics Taleo Enterprise 4 comments

Summary

Looking for a SQL Code to remove duplicate rows

Content

Hello,

I am using the Candidate Regulations "Race" field to report out hires information. I am finding that some hires have two values in this field .. for example "Race- White" as well as a null value. I would like to ensure I only see 1 row per candidate with the max Race value.  There are also some hires that do not have any information in this field and it comes through as blank (this is okay, but I cannot use the "Race is not null" filter therefore).  I attempted to use the SQL Code below, but it is still removing

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!