6 Replies Latest reply: Oct 14, 2015 6:17 AM by Bunny V RSS

    duplicate emali data in qlikview report

    vir vir

      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.