That's perfect! Thanks Arek! Cheers, Liisa
Liisa Koski Bioinformatics Programmer T: (450)358-2621 x104 DNA Landmarks Inc. 84 Richelieu St.-Jean-sur-Richelieu, J3B 6X3 Quebec, Canada [email protected] Arek Kasprzyk <[email protected]> 2009-06-18 09:32 To Syed Haider <[email protected]>, Liisa Koski <[email protected]> cc "[email protected]" <[email protected]>, BioMart mart-dev <[email protected]> Subject Re: [mart-dev] link dataset on _key colomn On 18/06/09 9:12 AM, "Syed Haider" <[email protected]> wrote: > Hi Liisa, > > you can definitely have as many _key columns in one table as you want to. > > Syed > Hi Lisa, There are certain rules to these columns. You would typically have one _key column in the main and additional _key column for each submain. Dimensions should have one _key column, identifying which main table they belong to. Can you give us an idea why do you need more 'key' columns so maybe we can explain better? A. > > Liisa Koski wrote: >> >> I think I have a related question...can you have two different _key >> columns in one table? >> >> Cheers, >> Liisa >> >> >> >> >> *Syed Haider <[email protected]>* >> Sent by: [email protected] >> >> 2009-06-18 08:30 >> >> >> To >> [email protected] >> cc >> "[email protected]" <[email protected]> >> Subject >> Re: [mart-dev] link dataset on _key colomn >> >> >> >> >> >> >> >> >> Hi Berenice, >> >> >> sure, its possible. you need to declare importable and exportable for >> the said fields. >> >> >> Cheers >> Syed >> >> >> [email protected] wrote: >>> >>> >>> Hi, >>> >>> I would like to known if it's possible to link a dataset via the _key >>> field. >>> For exemple, I have two dataset A and B. A contains a field Bid that I >>> would like to link to the dataset B on the field id_key. >>> >>> Thanks, >>> Bérénice >>
