Mixing Tables

[Cesarricardo]

Hi,

I think my douht is very simple but i just can't do it.

I have two table that are not related, i just have to mix all values of the table

Ex.

Table 1

Equipment	Model
ER0001	PMH36
ER0002	MD335

Table 2 

Date	Month
01/01/2023	january
01/02/2023	fabuary

Result

Equipment	date
ER0001	01/01/2023
ER0001	01/02/2023
ER0002	01/01/2023
ER0002	01/02/2023

[PabloDeheza · Accepted solution]

Hi there!

You can try using the CROSSJOIN Function like this:

CROSSJOIN( Equipment, Date )

Let me know if that helps!