Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qliklearnervir
New Contributor III

duplicate emali data in qlikview report

Hi ,

i am loading data as given below:

Book:

Distinct (Book_id) as ID,

From Book.QVD;

Left JOIN

LOAD DISTINCT

    UPPER([Email Adrress]) As [Email],

     ID

From Person.QVD;

NoConcatenate

Test:

Load Min(ID ) as ID, [Email]

resident Book

group by [Email]

;

But still i am getting Duplicate EMail ids .

Please suggest the solution /

additonally please suggest is there any alternative for Upper or Lower email address, because due to different font style also reflacting Duplicate email.

THanks.

6 Replies

Re: duplicate emali data in qlikview report

Book:

Distinct (Book_id) as ID,

From Book.QVD;

Left JOIN

LOAD DISTINCT

    UPPER([Email Adrress]) As [Email],

     ID

From Person.QVD;

Load only this tables and check. It s hard to judge the issue from this, please share the sample app and the qvd .

Re: duplicate emali data in qlikview report

one More thing , in the below table. Does the Email be same for different Different ID's eg. like for ID 1 and 2 can have the same email id ??

LOAD DISTINCT

    UPPER([Email Adrress]) As [Email],

     ID

From Person.QVD;

qliklearnervir
New Contributor III

Re: duplicate emali data in qlikview report

I just want the email ids....

Like Example:

ID  Email

1   abc@mail.com

2 abc@mail.com

3 ABC@mail.com

i only want abc@mail.com........because we have to send an email to list of mil ids.........

Highlighted

Re: duplicate emali data in qlikview report

Share your app with the qvd files will see what's the issue is

jyothish8807
Honored Contributor II

Re: duplicate emali data in qlikview report

Hi Vir,

Try this:

Book:

load

Distinct

trim(Upper(Book_id)) as ID,

From Book.QVD;

Left JOIN (Book)

LOAD DISTINCT

trim(upper(ID)) as ID,

trim(UPPER([Email Adrress])) As [Email],

From Person.QVD;

Try the out put now.

And yes, if you have multiple emails corresponding to one ID then you will get multiple output.

Regards

KC

Best Regards,
KC
bunnyv123
Contributor

Re: duplicate emali data in qlikview report

Hi,

You can use .

TRIM

Capitalize  functions

thanks

bunny

Community Browser