387123_en-US

liliconcom

Create duplicate data in a table by column in a different table

Good day community,  I am wondering if there is a way to duplicate data in "Big class" table (40 rows) by column in a Table "Region" (6 rows), intention is to assign for each set of Big class table a new column from Region to create total of 240 rows. 

Attaching files for details.

Thank you!!!

Data TableScriptingRe: Create duplicate data in a table by column in a different table

All you need to do is to do is a Cartesian Join

     Tables=>Join

and then select "Cartesian Join" from the Matching Specification