Hi Richard,
Depends on the structure and naming of your main tables. If both are
called something or other __main, as I suspect, then MartEditor would have
been trying to work out the relation between the two having made the
assumption that one was a subclass of the other. It does this by looking
for a single _key column in one, and another _key column by the same name
in the other that is accompanied by a second _key column of a different
name. If this convention is not followed then it can get confused.
Generally you should only have two main tables if one is a subclass of the
other. If they are unrelated, then you should put them in two separate
datasets instead.
Posting the structure of your two main tables would be very helpful - then
we can use them to determine for sure if this was the problem.
The main table names are:
test_reactome_18__pathway__main
|test_reactome_18__reaction__main
The tables have rather a lot of columns, but basically, they are unrelated,
and they both have a single, identically named, _key column. I guess that
is the problem.
(Also if your tables are empty it gets confused too.)
No, there is data in both tables.
Cheers,
David.
