Hi All,
I am trying to create a simpel table to handle geneId and productId but the data file which i want to read in has for some genes more than one productId ex:
GeneId | ProID1 /// ProID2 /// ProID3
Now how does one input the same information without having GeneId listed in the table more than once if possible?!!!
If i read-in the info. just as it appears in the file then will the querying be a big problem since there is more than one ProID/ per gene and not to mention '///' characters!
Thanks in advance.
Hrishi
AFFX-HSAC07/X00351_3_st
| ---
| ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624
|
|
AFFX-HSAC07/X00351_3_st
| ---
| ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624
|
|
AFFX-HSAC07/X00351_3_st
| ---
| ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624
|
|