Forum Discussion

Kohrinn's avatar
Kohrinn
Helper I
3 years ago

Get data from transitive/star relationship

Hi,

I have a model as follows:

 

In my main table, I have data from CIP_ReportData. Now, I would like to get 'Name' from CIP_LoopEncription based on 'LoopID' I have in my CIP_ReportData. When I drag 'Name' to my table, whole thing crashes.

 

 

When I create a relationship, it's Many-to-many. 

 

How to get the value?

 

 

Thanks,

Joanna

Need Help

2 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    hello Kohrinn ,

     

    so you create a table between these two tables that has the LoopID and the name and connect it to these two tables through loop ID and use it to visualise.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť

    Follow me on Linkedin
    Vote For my Ideađź’ˇ

     

    • Kohrinn's avatar
      Kohrinn
      Helper I
      3 years ago

      Isn't there a way to get to the table that I already have? I was thinking about a measure, but not sure anymore.