topic Show duplicate records visual in QlikView

Show duplicate records visual

Mon, 27 Jul 2009 17:08:59 GMT

Hi,

With some help( http://community.qlik.com/forums/t/18305.aspx) I managed to accomplished to extract multiple email records from a database. The straight table show only the email addresses that ore existing more than once.

Now i got the problem that i can't get this visual. The straight table only shows them once.

My goal is to show the them the times they exist for real, so i can trace them back to the person.

Regards.

Show duplicate records visual

Mon, 27 Jul 2009 19:54:07 GMT

Hi Simon,

While loading data use Rowno() funtion in your script as

Load Rowno() as Rn, emailid, * from TableName;

Regards,

Amit

Show duplicate records visual

Mon, 27 Jul 2009 22:19:31 GMT

Hi asomani ,

Thanks for the reply. Where in my script do I have to add this Rowno function exactly? I tried to get it working but didn't succeed.
I already loaded the table:

QUALIFY*;
UNQUALIFY person_id;
Emailadresses:
LOAD "email_id",
//AUTONUMBERHASH128(contact_id, person_id) AS ContactPerson_id,
"contact_id",
"person_id",
"project_id",
"reserved_id1",
"reserved_id2",
protocol,
type,
description,
"email_address",
rank,
registered,
"registered_associate_id",
updated,
"updated_associate_id",
updatedCount;
SQL SELECT *
FROM NCH.crm5.email;
UNQUALIFY *;

Regards.