Find the rows of table if two fields rows are same

[rishikeshtiwari]

Hi All,

I have an Employee table. In this table there are 7 fields . The value of two field EmployeeId and EmpName are duplicate

in table on some places highlighted by yellow colour in Excel.

EmployeeId

EmpNam

I need only those columns of the table whether these EmployeeId and EmpName are duplicate as  shown in Excel result part.

I have a requirement that I want the Sales and description for only these duplicate yellow colored fields.

If  both the fields are not repeated then it should be removed..

Thanks  in  Adv

Rishi

[sunny_talwar]

This:

Table:

LOAD Key,

     EmployeeId,

     EmpName,

     EmpSalary,

     DateofJoin,

     City,

     Sales

FROM

Org.xlsx

(ooxml, embedded labels, table is Employee);

Right Join (Table)

LOAD EmployeeId

Where Count > 1;

LOAD EmployeeId,

  Count(EmployeeId) as Count

Resident Table

Group By EmployeeId;

[swuehl]

Isn't this mostly the same as requested here

Need Only Duplicate Rows

If yes, please don't post multiple times the same question, have a little patience to get an answer.

If no, please specify what the difference is.

[sunny_talwar]

Seem almost same, with a slight difference in where the duplication is. But yes you are right, if they are essentially the same requirement, I would also suggest not creating duplicate threads.