6 Replies Latest reply: Mar 17, 2017 5:36 AM by Rajesh RS RSS

    Branding records based on condition

    Supriya R

      Hi,

       

      i have a data where i need to brand for batch like below, Here Britanna client has 8 batch were it branded to 4 and others each batch with each brand.

       

        

      clientclient_idbatchbatch_id
      Parlegi1Parlegi 90$21
      Parlegi1Parlegi 25$22
      Britanna2Britanna crf45
      Britanna2Britanna crf & Lpf43
      Britanna2Mango crf46
      Britanna2Mango crf & Lpf44
      Britanna2FineApple crf47
      Britanna2FineApple crf & Lpf48
      Britanna2gauva crf49
      Britanna2gauva  crf & Lpf53
      UNIBIC3UNIBIC17/754
      UNIBIC3newflavor67
      UNIBIC3yflavor56
      Kikat4Kitkat target - 2nd58

       

         

      clientclient_idbatchbatch_idBrand
      Parlegi1Parlegi 90$21Brand 1
      Parlegi1Parlegi 25$22Brand 2
      Britanna2Britanna crf45Brand 1
      Britanna2Britanna crf & Lpf43Brand 1
      Britanna2Mango crf46Brand 2
      Britanna2Mango crf & Lpf44Brand 2
      Britanna2FineApple crf47Brand 3
      Britanna2FineApple crf & Lpf48Brand 3
      Britanna2gauva crf49Brand 4
      Britanna2gauva  crf & Lpf53Brand 4
      UNIBIC3UNIBIC17/754Brand 1
      UNIBIC3newflavor67Brand 2
      UNIBIC3yflavor56Brand 3
      Kikat4Kitkat target - 2nd58Brand 1

       

      Script:

      Load client,

      client_id,

      batch,

      batch_id ;

      SQL Select client,

      client_id,

      batch,

      batch_id

      from  ClientDetails;


       

      How to brand one client with one way and other client batch with other way in Script?