AnsweredAssumed Answered

Scripting Data Pairs to Populate a New Table

Question asked by klawsure on Aug 17, 2016
Latest reply on Aug 19, 2016 by 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

Outcomes