Forum Discussion

zac_lim's avatar
zac_lim
New Member
9 years ago

Relationship between Channel Views and Programme

Hi guys,   This was an exercise given several days ago. I could not find a good way to solve the relationship between these two tables.     I would like to find information about the c...
Need Help
zac_lim's avatar
zac_lim
New Member
9 years ago

So for example:

 

On the second table,

 

On 1st september 2016, 13:12 - 13:22, one episode of the programme AALAM GUMBALL is showing.

 

On the 5mins interval table, under the CNArabia channel (you can't see it from the snapshot) for 1st September 2016, there will be channel views at period 13:15 and 13.20 (5min interval). At this point, this is the snapshot of channel views for AALAM GUMBALL 13:12 - 13:22.

 

Is there anyway to match these? or create a relationship?

 

I hope this is clear enough. Thanks

 

Zac

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Ya i get clearly what u want .

 

We can't create relationship like this case. bec relationship only works for matching cases am i right ?

 

Sorry dude .

 

  • zac_lim's avatar
    zac_lim
    New Member
    9 years ago

    Yeah, its impossible in its current state unless maybe we create a new table or clean the data. That's why I used an alternate solution but it was inelegant and tedious. I was wondering if anyone in the community might have a unique perspective to solving it.

     

    Thanks though