Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a problem with linking tables.
I've got one table with columns named: Game-ID;Hometeam;Awayteam;Result. And another table with columns named: Team;Teamvalue
So I want, that when I click on a specific Team, for example ManchesterUnited, that all Games are shown where Manchester is either the Hometeam or the Awayteam.
At the moment the two tables stand alone in the table viewer. And when I click on Manchester nothing happens 🙂 How can I link them?
Thank you very much
U need some kind of common id field between the tables to link them, is hometeam in table 1 and team in table 2 are same,
if they are same they can be linked by renaming team as hometeam..
-Sundar
If they are same, you can link them while loading like,
load
team as Hometeam,
teamvalue
from src2.xlsx;
-sundar
Hi Johannes,
how about loading a link table like this:
LINK:
LOAD
Game-ID,
Hometeam as Team
RESIDENT [fact table];
CONCATENATE (LINK)
LOAD
Game-ID,
Awayteam as Team
RESIDENT [fact table];
where [fact table] is the previously loaded table containing the results.
Marcus
You should definitely do what Marcus suggests.
From a theoretical perspective, it is the same problem as the one with a Canonical Date - although it is a date in one case and a Team in the other.
HIC