How to create a table and making multiple entries for each line

[justcotto]

Hi, I am trying to create a table to use for section access.  I have a table with IDs and I have a separate list of Business Units.  I want to create a table that stores a row for each ID and BU.  Example:

Table 1

ID

1111

2222

3333

4444

Tables 2:

BU

1234

4321

5678

Table I want:

ID                      BU

1111                1234

1111                4321

1111                5678

2222                1234

2222                4321

2222                5678

3333                1234

3333                4321

3333                5678

[Taoufiq_Zarra · Accepted solution]

Maye be :

Table1:
load * inline [
ID

1111

2222

3333

4444
];
 
join

load * inline [
BU

1234

4321

5678
]

output :