Link Tables

[#1]

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

[sundarakumar]

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

[sundarakumar]

If they are same, you can link them while loading like,

load

team as Hometeam,

teamvalue

from src2.xlsx;

-sundar

[marcus_malinow]

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

[hic]

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