3 Replies Latest reply: Aug 15, 2011 9:03 AM by Krishnamoorthy Neeraj RSS

    use for loop while loading from a table

      Hi All,

      I have TABLE1, that has 3 fields : LETTER, WORD, LOOP

       

      LETTER    WORD       LOOP

       

      A               Apple        2

      B               Ball           3

      C               Cat           1

       

       

      What I am trying to generate is TABLE2 which looks like this:

       

      LETTER    WORD       NEWFIELD

       

      A               Apple        2 Apple

      A               Apple        2 Apple

      B               Ball           3 Ball

      B               Ball           3 Ball

      B               Ball           3 Ball

      C               Cat           1 Cat

       

      ie. the rows should get duplicated based on the value of LOOP.

       

      Thanks,

      Neeraj