6 Replies Latest reply on Aug 19, 2016 11:08 AM by klawsure

    Scripting Data Pairs to Populate a New Table

    klawsure

      Hello - I am having trouble with a script to pair each record from Table 1 with each record from Table 2 to populate Table 3.

       

      For example purposes lets say I have a Table 1 with flower names and a Table 2 with flower colors. What I want is to run a script that will pair each flower with each color and populate Table 3 as shown below.

       

      Any help would be greatly appreciated!!! 

       

        

      Table 1
      Flower IDFlower Name
      F-01Daisy
      F-02Lilly
      F-03Rose

        

      Table 2
      Flower IDFlower Color
      F-01Daisy
      F-02Lilly
      F-03Rose

         

      Table 3
      Pair IDFlower NameFlower Color
      P-01DaisyRed
      P-02DaisyYellow
      P-03DaisyWhite
      P-04LillyRed
      P-05LillyYellow
      P-06LillyWhite
      P-07RoseRed
      P-08RoseYellow
      P-09RoseWhite