Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

circular dependency --help please

hi   i am just trying to relate tables using bridge table . where i am facing the circlaur dependency .   dim: feedyard sex ration   data table : feedyard sex ration index alex bike 1200 0...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    1. copy "dimension" and paste, then i get "dimension2" table,

        in this table with only one column, "remove rows"->remove duplicates

    2. copy "data" and paste, then i get "data2" table,

        in this table, click on the [index] column and select "Remove other columns", then Removed Duplicates

    3.in "dimension2" table, add a custome column

     

    Then expand this column

     

    Best Regards

    Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi v-juanli-msft : can you provide steps for add column please

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

1. copy "dimension" and paste, then i get "dimension2" table,

    in this table with only one column, "remove rows"->remove duplicates

2. copy "data" and paste, then i get "data2" table,

    in this table, click on the [index] column and select "Remove other columns", then Removed Duplicates

3.in "dimension2" table, add a custome column

 

Then expand this column

 

Best Regards

Maggie