Forum Discussion

Aysen's avatar
Aysen
Frequent Visitor
3 years ago
Solved

How I can create relationship between excel sheet with no same or related column with fact table?

Hi all, I have an excel sheet which have loaded that in data modeling, so new table is exist, but for creating relationship between this new table and fact table, thare is not any same column, for e...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi,  Aysen 

    According to your description, you want to get the [TVD] in the excel sheet when you enter an the value of the [MD] . And you want to get this value in your visual created by the fact table but two tables has no related columns to create relationship?

     

    For your needs, if you want to input the corresponding value in the Excelsheet, and then get the corresponding [TVD], then we can directly get the corresponding value without creating a relationship.

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi,  Aysen 

According to your description, you want to get the [TVD] in the excel sheet when you enter an the value of the [MD] . And you want to get this value in your visual created by the fact table but two tables has no related columns to create relationship?

 

For your needs, if you want to input the corresponding value in the Excelsheet, and then get the corresponding [TVD], then we can directly get the corresponding value without creating a relationship.