I want to do what I think is a simple cross-table join.
I have a table with a list of project week start dates (lets assume 40 weeks).
I have a separate table with a list of all resources working on the project (lets assume 20 resources)
I would like an automated way to create a new master table which has a row for unique combination of weeks and resources (i.e. 40 x 20 = 800 rows)
I have access to Datamesh and datatables but not data bridge.
What is my best option to create the new master table?