For every row in Table 1, add all columns from Table 2

[ccyong]

Hi all - i have been trying to find answers but can't - hope if you can shed some light. What i have wanted to do is relatively simple:

Table 1

John

Joe

Lee

Table 2

Orange

Apple

I want to get Table 3 which is 

Table 3
John	Orange
John	Apple
Joe	Orange
Joe	Apple
Lee	Orange
Lee	Apple

Which is basically for every entry i have in table 1, add all rows from Table 2. thanks!

[Ashish_Mathur]

Hi,

You can also solve this in the Query Editor.  In Table1, write this M language formula =Table2.  Then simple go and expand the second column.

[PattemManohar · Accepted solution]

@ccyong Please create a new table using below

NewTableName = CROSSJOIN(Table1,Table2)

[ccyong]

Ah cant believe I missed this particular function in documentation! thank you!