Joining contents of two tables into one new calculated table

[carinat]

I'm trying to combine two tables into a new calculated one. The tables don't have the same amount of columns so I can't use a UNION. They do however have two columns with the same name and sort of data.

Table1    Table2

col1        col1

col2        col2

colA       colB

colC

I would now like a Table3 containing col1 and col2 from both tables 1 and 2. Table3 needs to only have those two columns (and not 4 - i.e. not two from each but just a combination).

I still want to keep Table1 and Table2 with all their columns so I can't just remove them in the query and thereafter use UNION either.

Does anyone have an idea of how to proceed?

[itayrom · Accepted solution]

The following expression should do the trick-

Table3 = UNION(
	SELECTCOLUMNS(Table1, "col1", [col1], "col2", [col2]),
	SELECTCOLUMNS(Table2, "col1", [col1], "col2", [col2])
)

[carinat]

Thanks a lot itayrom!

[itayrom]

You're most welcome.