Create a new table

[Anonymous]

Hi need help creating a table 

i have this table

Test=

CALENDAR(Date(2022,06,01),(Date(2022,06,30))

and from another table called Goals need the following

Test)

Date

06/01/2022

06/02/2022

06/03/2022

06/04/2022

06/05/2022

06/06/2022

...

on the test table need to add each of the lines from the table Goals and repeat it for each of the lines on the table Date but DONT using 

union all

union all

union all

for each of the lines, would really appreciate the help 

[Seanan]

Hi @Anonymous 

Are you looking to achive something like this?

If not would you be able to post an example of what you want your table to show?

[Anonymous]

kinda, have this table 

and need to join this one 

but need to repeat each of the lines for example Canada 30 times for each date just the way is done on the first picture, for all of the lines on the second table (second picture)

[Seanan · Accepted solution]

Hi @Anonymous 

If you just want to display this data in a visual table within the report you can create a many to one relationship between the your dates table and second table as shown below:

Once done you can then display all of the dates from the dates table along with all of the other neccessary information from the second table.

Please let me know if this helped solve your problem.