Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Merging 2 data sets based on Dates and supplier name

Hi I am trying to merge 2 sets of data to provide 1 holistic view of the supplier. I have: One table / dataset which provides supplier spend A second table / dataset which provides the supplier ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    You are making several many to many connections and with both way filtering, this is causing you model to have the connections already made from each side.

     

    Believe that the best way is to have a Supplier dimension table with unique values that make the connections to the suppliers data with one to many relationship.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

You are making several many to many connections and with both way filtering, this is causing you model to have the connections already made from each side.

 

Believe that the best way is to have a Supplier dimension table with unique values that make the connections to the suppliers data with one to many relationship.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi MFelix 

    Its not 100% what i was trying to acheive, however i was a bit naive and it has worked. Thank you.

     

    I will now go away and find the next problem, hopefully you are around to get be back on track.

     

     

     

    Thanks again

     

    Lee