topic Re: duplicate emali data in qlikview report in QlikView

duplicate emali data in qlikview report

qliklearnervir — Wed, 14 Oct 2015 09:22:50 GMT

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],

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.

Re: duplicate emali data in qlikview report

avinashelite — Wed, 14 Oct 2015 09:41:50 GMT

Book:

Distinct (Book_id) as ID,

From Book.QVD;

Left JOIN

LOAD DISTINCT

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

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

avinashelite — Wed, 14 Oct 2015 09:46:45 GMT

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],

From Person.QVD;

Re: duplicate emali data in qlikview report

qliklearnervir — Wed, 14 Oct 2015 09:49:53 GMT

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.........

Re: duplicate emali data in qlikview report

avinashelite — Wed, 14 Oct 2015 09:54:13 GMT

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

Re: duplicate emali data in qlikview report

jyothish8807 — Wed, 14 Oct 2015 10:03:42 GMT

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

Re: duplicate emali data in qlikview report

Anonymous — Wed, 14 Oct 2015 10:17:35 GMT

Hi,

You can use .

TRIM

Capitalize functions

thanks

bunny