Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Getting a Circular Dependency Error in relationship when using 2 concatenated Columns of 2 tables

Hello Everyone,   I have two tables and I am trying to create a relationship between these two tables with the best possible scenario.   Please refer to the tables below:   Table 1       ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello All,

    I Figured it out. The reason it was showing a Circular dependency is because the combination in Column Conc_D was repeating. 

     

    To address this I created a Subset Table - Table 3 with Unique Values of Column Conc_D and then linked Table 1 with Table 3.  there were no circular Dependencies this time as Conc_D had unique values.

     

    Regards,

    Vamshi Regalla 

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  Anonymous 

If the calculated column B of Table1 and the calculated column C of Table2 are created based on the same column A1 in table1, it is not recommended to establish a relationship between column B and column C.

 

Best Regards,
Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you. is there a workaround to establish relationship between these two tables considering 3 columns( vendor Name, Yeaar and Month) from each table 

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      5 years ago

      Hi,  Anonymous 

      Take a try to  convert the calculated column B of Table1 into a actual column, for example, create a custom column B2 in 'Transform Data' to associate the corresponding fields. 

       

      Best Regards,
      Community Support Team _ Eason