Forum Discussion

limewire's avatar
limewire
Helper I
7 years ago
Solved

Relationship problem after appended data

Greetings~   Current situation: I had a nice relationship going between my query and 2 reference queries where I filtered for variables in the same column. This was so that I could create a calulat...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    limewire for everyone else, we added unique key in both the tables by concatenating year & program name columns and relationship become 1 to many and every existing calculation worked as expected. Cheers!!!

     

     

     

vanessafvg's avatar
vanessafvg
Community Champion
7 years ago

limewire  is there any chance you can share the data? or post a picture of relationship with the fulll structures of the tables, its probably going to be easier if you share the data

limewire's avatar
limewire
Helper I
7 years ago

vanessafvg 

I can't share the data unfortunately but I can do my best with pictures!  

CCEOI and Net Views have the same columns but differ in terms of category. My goal is to create a calculated column using CCEOI values as the numerator and Net Views values as the denominator.  I was able to this with a calucated column before I appended the data. How can I do it now? 

relationship table ~ renamed the tables to make it easier