Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Manage Relationships between Tables

Hi,   I have two tables called loans and Incentives. I loaded the loans table initially and then the incentives table. An relationship was auto detected based on a common column in both the table....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    What exactly are you trying to do?  When i open the file, i do not see any problem (and the relationship is intact).  Furthermore, you should select the first 3 columns in the Incentives table and select "Unpivot Other columns".  You should should create a Dimension table of Office_uuid and then build a relationship (Many to One and Single) from the office_uid of the Incentives and Loans table to the dimension table.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

What exactly are you trying to do?  When i open the file, i do not see any problem (and the relationship is intact).  Furthermore, you should select the first 3 columns in the Incentives table and select "Unpivot Other columns".  You should should create a Dimension table of Office_uuid and then build a relationship (Many to One and Single) from the office_uid of the Incentives and Loans table to the dimension table.