Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
asheppardwork
Contributor III
Contributor III

Joining Multiple Resident tables with Syn keys

I have a question that I have hit a bit of a wall on.  I am trying to move a calculation from a bar chart to the load statement because of the amount of time it takes to load the page.  I am needing to join multiple resident tables but can't seem to find the right syntax or whatever. 

I need to have the fields from the Report_Table, and each IntervalMatch table to then make a third table; I have tried several different solutions but none create any other tables or they create another $Syn table but they match every other table which is in correct. How can I get what I need?

 

Code for the Intervals table(s):
 LET varMinDate = Num(MakeDate(2021));                 

 LET varMaxDate = Floor(num(Today()));

 CalendarBuild:

 LOAD

               $(varMinDate) + Iterno()-1 As Num,

               Date($(varMinDate) + IterNo() - 1) as TempDate

               AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

 Intervals_30:

 Load

               DATE(TempDate-31, 'MM/DD/YYYY') AS From_Date_30
               
               ,DATE(TempDate, 'MM/DD/YYYY') AS To_Date_30
               
               , '30Day_Range' AS IntervalName_30



 Resident CalendarBuild;

 


  //////////////////////////////////


 Intervals_60:

 Load

               DATE(TempDate-60, 'MM/DD/YYYY') AS From_Date_60
               
               ,DATE(TempDate, 'MM/DD/YYYY') AS To_Date_60
               
               , '60Day_Range' AS IntervalName_60



 Resident CalendarBuild;
Labels (2)
0 Replies