Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

qliklearnervir
Not applicable

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
avinashelite
Not applicable

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 .

avinashelite
Not applicable

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
Not applicable

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

avinashelite
Not applicable

Re: duplicate emali data in qlikview report

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

jyothish8807
Not applicable

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
Not applicable

Re: duplicate emali data in qlikview report

Hi,

You can use .

TRIM

Capitalize  functions

thanks

bunny