Discussion Board for collaboration on QlikView Scripting.
i am loading data as given below:
Distinct (Book_id) as ID,
UPPER([Email Adrress]) As [Email],
Load Min(ID ) as ID, [Email]
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.
Load only this tables and check. It s hard to judge the issue from this, please share the sample app and the qvd .
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 ??
I just want the email ids....
i only want email@example.com........because we have to send an email to list of mil ids.........
Share your app with the qvd files will see what's the issue is
trim(Upper(Book_id)) as ID,
Left JOIN (Book)
trim(upper(ID)) as ID,
trim(UPPER([Email Adrress])) As [Email],
Try the out put now.
And yes, if you have multiple emails corresponding to one ID then you will get multiple output.
You can use .