I have the following three tables in a custom database: Population [id, name] Marker [id, rsid, allele_A, allele_B] AlleleFrequency [id, fk_population_id, fk_marker_id, freq]
How would I go about creating a mart that the user can query for markers and get results in the form: rsid | CEU_freq | JPT_freq | YRI_freq rs12 | 0.05 | 0.55 | 0.75 rs34 | 0.95 | 0.65 | 0.05 In other words, the number of attributes available depends on how many unique populations there are? The automate push action and partitioning seem to suggest this sort of structure might be possible. Thanks in advance
