Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Simon,
While loading data use Rowno() funtion in your script as
Load Rowno() as Rn, emailid, * from TableName;
Regards,
Amit
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.