Forum Discussion

JohnnyT48's avatar
JohnnyT48
Helper I
2 years ago
Solved

Managing Multiple Relationships Between Tables

I have two data tables with several unique identifiers. 1. Company ID, (Note Company Names Differ) 2. Project Name and No 3. End Of Month I have created a table to manage the Company ID Linked t...
Need Help
  • kpost's avatar
    kpost
    2 years ago

    You can only have a single active relationship between two tables.

     

    I would make a new calculated Date Dimension table using CALENDAR() that has an active many to one relationship to the date columns in both of those tables.  Then use the [date] column in your new Date Dimension table for all visuals, filters, etc.

     

    The proper syntax is something like this, my example only generates date from 2024-01-01 to 2024-12-31.  You will want to choose a date range that is suitable for your needs.

     

    Date_Table = CALENDAR(DATE(2024,1,1), DATE(2024,12,31))


kpost's avatar
kpost
Solution Sage
2 years ago

You can only have a single active relationship between two tables.

 

I would make a new calculated Date Dimension table using CALENDAR() that has an active many to one relationship to the date columns in both of those tables.  Then use the [date] column in your new Date Dimension table for all visuals, filters, etc.

 

The proper syntax is something like this, my example only generates date from 2024-01-01 to 2024-12-31.  You will want to choose a date range that is suitable for your needs.

 

Date_Table = CALENDAR(DATE(2024,1,1), DATE(2024,12,31))


JohnnyT48's avatar
JohnnyT48
Helper I
2 years ago

Thank you very much, really appreciate the help.

Thanks

Johnny