Combining Tables with No Matching Column

[newpbiuser01]

Hello,

I have two data tables coming from seperate sources, and I need to combine them both. The rows in the subcategory table are a subset of the category table and I'm trying to combine them so we have one  for each subcategory for every category. Since there are no matching columns, I'm not sure how to merge the tables. 

Category Table: 

Category

A

B

C

Subcategory Table:

Subcategory

ABC

DEF

GHI

JKL

MNO

PQR

STU

Combined Table: 

Category	Subcategory
A	ABC
A	DEF
A	GHI
A	JKL
A	MNO
A	PQR
A	STU
B	ABC
B	DEF
B	GHI
B	JKL
B	MNO
B	PQR
B	STU
C	ABC
C	DEF
C	GHI
C	JKL
C	MNO
C	PQR
C	STU

How could I go about combining the tables? I'd really appreciate any help!

Thank you!

[rsbin · Accepted solution]

@newpbiuser01 ,

Use the CROSSJOIN function:

NewTable = CROSSJOIN( Category, SubCategory )

Regards,

[newpbiuser01]

Thank you!