Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a new table

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 
Need Help
  • Seanan's avatar
    Seanan
    4 years ago

    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.

3 Replies

  • Seanan's avatar
    Seanan
    Solution Supplier
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Seanan
        Solution Supplier
        4 years ago

        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.