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

 

will this table gets refreshed will scheduled in prod?. I mean if the values (attributes)gets added to the dimension ( productname say) will this data be also reflects to the bridge table automatically without manual intervension?

 

one more question : if i paste the query using query editor will this query creates other two tales and then join ?. Will this step refreshes the data in bridge table  based on data change other two tables ?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi v-juanli-msft

3.in Query1:

Add column from Query2 , then expand the column .

 

can you send me screenshot how you did this  from query editor . I am not able to add column from another table .can you help here ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    hi v-juanli-msft  if you used custom calculation tab for adding column .if yes can you share code please?