topic Re: Find the rows of table if two fields rows are same in QlikView

Find the rows of table if two fields rows are same

rishikeshtiwari — Tue, 02 Feb 2016 12:14:05 GMT

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

Re: Find the rows of table if two fields rows are same

sunny_talwar — Tue, 02 Feb 2016 13:40:04 GMT

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;

Re: Find the rows of table if two fields rows are same

swuehl — Tue, 02 Feb 2016 13:44:36 GMT

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.

Re: Find the rows of table if two fields rows are same

sunny_talwar — Tue, 02 Feb 2016 13:50:13 GMT

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.