Combine two columns and multiply occurrences

[vipett]

I have a column called date in one table :

2021-01-01

2021-01-02

2021-01-03

2021-01-04

etc

And another column called Items in another table

Item A

Item B

Item C

Item D

etc

I would like to create a new table with looks like this

Date	Item
2021-01-01	A
2021-01-01	B
2021-01-01	C
2021-01-01	D
2021-01-02	A
2021-01-02	B
2021-01-02	C
2021-01-02	D
etc

What's the best way of doing this?

[SpartaBI · Accepted solution]

@vipett 
TABLE = CROSSJOIN(Table1, Table2)

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂