topic Re: Need Only Duplicate Rows in QlikView

Need Only Duplicate Rows

rishikeshtiwari — Tue, 02 Feb 2016 11:49:02 GMT

Hi All,

I have a table having some duplicate rows. I have a requirement that I need only the duplicate rows of the table.

Please find the attached excel with result.

Thanks

Rishi

Re: Need Only Duplicate Rows

sunny_talwar — Tue, 02 Feb 2016 13:26:52 GMT

Try this:

Table:

LOAD Key,

EmployeeId,

EmpName,

EmpSalary,

DateofJoin,

City

FROM

Employee.xlsx

(ooxml, embedded labels, table is Employee);

Right Join (Table)

LOAD Key

Where Count > 1;

LOAD Key,

Count(Key) as Count

Resident Table

Group By Key;

Re: Need Only Duplicate Rows

Gysbert_Wassenaar — Tue, 02 Feb 2016 18:47:45 GMT

Another option:

Result:

LOAD

Key,

EmployeeId,

EmpName,

EmpSalary,

DateofJoin,

City

WHERE

Check>1;

LOAD Key,

EmployeeId,

EmpName,

EmpSalary,

DateofJoin,

City,

FROM

[comm203862.xlsx] (ooxml, embedded labels, table is Employee)

;