The join can be found by looking at the configs for the two datasets in MartEditor and looking for an Exportable in one that has the same name as an Importable in the other (usually there's one of each in both datasets in order to allow bidirectional joins).
The attributes named in the Exportable are then used to populate the filters named in the Importable . You can configure the way it works by changing the attributes and filters - but there always needs to be the same number on both sides otherwise it can't match them up. If more than one Exportable+Importable set match, then BioMart uses the first one it finds. It's important to remember that as the join is done based on preconfigured settings inside the mart configs, not on run-time settings, and so you can't control the way the join is performed between datasets which are not under your direct control. cheers, Richard Nikhil Teletia wrote: > Hi > I have one query regarding merging/joining result from multiple dataset > ( in biomart case multiple dataset means 2 dataset ). > > as of now current biomart forms allow us to join/merge result from 2 > dataset. I am just trying to understand on what attribute this > particular join is done ? Is there any documentation which can help me > to understand this. From UI it seems result are merged/joined on > Associated Gene DB. > > My goal is to join 2 different dataset on 'choromosome Location'. Is > there any configuration which can make this possible. Can I configure > the join/merging attribute ? > > Thanks > Nikhil > -- Richard Holland, BSc MBCS Finance Director, Eagle Genomics Ltd T: +44 (0)1223 654481 ext 3 | E: [email protected] http://www.eaglegenomics.com/
