1 Reply Latest reply on Jun 26, 2018 4:49 AM by Zhouyi Zhang

    Matching using different methods

    AJ.Yusuf

      Hi All I would like to find matching values using different dimensions and count finding repeat customer

       

      For example

       

      If Basecustomer Id match

       

      OR

       

       

      Phone Number (Mobile OR Landline)

       

      OR

       

      Email  ignoring any email with the following words ( 'noemail%' , 'nomail%' )

       

      OR

       

      (First name + Last name + Postcode Match)

       

       

       

       

      How do I create a calculation that will consider all the above conditions?

       

      I am just counting for each year say 2000 -2018

       

      How many previous were matching with the above conditons ...