0 Replies Latest reply: Mar 28, 2013 1:56 AM by Selvakumar S RSS

    Mapping of Values

      Hi All,

       

      I wan to map two column values from 2 different table like below, (Both table are linked using key 1). Column 1 is having Main Problem and Column 2 is having different root cause for the problem.

       

      Table 1Table 2
      Column 1Column 2
      9191   01
      91   02
      91   03
      91   04
      91   05
      91   06
      91   07
      91   08
      91   09
      9292   01
      92   02
      92   03
      92   04
      92   05
      92   06
      92   07
      92   08
      92   09
      92   10
      92   11
      92   12
      92   13
      92   14

       

      Actually i'm getting value like this,

       

      Table 1
      Column 1
      0
      91
      92
      93
      94
      95
      96
      97
      98

       

      Table 2
      Column 2
      92   **
      91   01
      91   02
      91   03
      91   04
      91   05
      91   06
      91   07
      91   08
      91   09
      92   01
      92   02
      92   03
      92   04
      92   05
      92   06
      92   07
      92   08
      92   09
      92   10
      92   11
      92   12
      92   13
      92   14

       

      Thanks,

      Selva