9 Replies Latest reply: May 30, 2014 11:10 AM by Stefan Wühl RSS

    Take data from one column and populate in another column

    lakwinder singh

      Hi,

       

      I need to match ACCOUNT NO to a POLICY NO, if it matches, in this example account no 100000 matches policy no 100000 so the account type is AAAA (That's easy).  The hard bit, i need to create another column and populate all the other Policy no for Account no 100000 with AAAA.

       

      OLD

       

      ACCOUNT NOPOLICY NOACCOUNT  TYPE
      100000100000AAAA
      100000100001PASI
      100000100002LASI
      100000100003PAAA
      100000100004KAAA
      100000100005IUAJ
      100000100006ASSA
      627811627811BBBB
      627811627812QAWS
      627811627813HDGD
      627811627814SHAF
      627811627815AJSS
      783793783793LSD
      783793783794SJS
      783793783795HJS
      783793783796AHA
      783793783797OOO

       

       

      REQUIRED

       

      ACCOUNT NOPOLICY NOACCOUNT  TYPENEW COLUMN
      100000100000AAAAAAAA
      100000100001PASIAAAA
      100000100002LASIAAAA
      100000100003PAAAAAAA
      100000100004KAAAAAAA
      100000100005IUAJAAAA
      100000100006ASSAAAAA
      627811627811BBBBBBBB
      627811627812QAWSBBBB
      627811627813HDGDBBBB
      627811627814SHAFBBBB
      627811627815AJSSBBBB
      783793783793LSDLSD
      783793783794SJSLSD
      783793783795HJSLSD
      783793783796AHALSD
      783793783797OOOLSD

       

       

      Thanks guys.