Using cohort browser, adding columns for 300 fields for a list of participant is going to be very tedious task. I have the field ids of those 300 fields. Is there a way to add those fields through scripts or through SQL database query?
Something like `dx extract_dataset` should work. While dx extract_dataset doesn't require using a spark node, depending on the size of the data/number of fields you may need to use a spark node
Comments
1 comment
Something like `dx extract_dataset` should work. While dx extract_dataset doesn't require using a spark node, depending on the size of the data/number of fields you may need to use a spark node
https://documentation.dnanexus.com/user/helpstrings-of-sdk-command-line-utilities#extract_dataset
@Ondrej Klempir? also wrote a really nice comprehensive post about different ways you can go about extracting phenotype data which could be useful to you as well: https://community.dnanexus.com/s/question/0D5t000004SBm0eCAD/query-of-the-week-1-export-phenotypic-data-to-a-file
Here is another related post by Ondrej as well: https://community.dnanexus.com/s/question/0D5t000004SF0MOCA1/query-of-the-week-5-extracting-fields-for-a-whole-phenotypic-category
Please sign in to leave a comment.