Forum Discussion
Solved
Mixing Tables
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 |
Hi there!
You can try using the CROSSJOIN Function like this:
CROSSJOIN( Equipment, Date )
Let me know if that helps!
1 Reply
- PabloDeheza
Solution Sage
Hi there!
You can try using the CROSSJOIN Function like this:
CROSSJOIN( Equipment, Date )
Let me know if that helps!