topic Re: Create duplicate data in a table by column in a different table in Discussions

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

AndresGlez — Sat, 10 Jun 2023 23:30:30 GMT

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!!!

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

txnelson — Thu, 20 May 2021 05:30:04 GMT

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

Tables=>Join

and then select "Cartesian Join" from the Matching Specification

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

AndresGlez — Thu, 20 May 2021 14:20:05 GMT

Thank you @txnelson , I did not know this option, this fixed my problem,