Table Exporter - Runtime to Export Phenotype Variables
Hi all,
I am trying to create a cohort table using the table exporter apps for around 500 phenotype variables to use in RStudio. I've set up a test run on a subset of around 20 variables which appears to run without error, however it doesn't manage to complete even after running for hours.
Is there an estimated time for the tool to run, or is there something that I am doing wrong?
Here is the screenshot of the tool settings I am using, all other options are left blank. Thanks!
Comments
2 comments
Update!
It appears my mistake was not specificying entity, after specifying “participant” as my entity the exporter ran within 8 minutes at a cost of £0.0287. This was for a cohort with ~190 variables.
Without specifying entity I had the same job run for over 8 hours before I terminated it due to cost.
I found the solution reading through these examples on github https://github.com/UK-Biobank/UKB-RAP-Notebooks-Access/tree/main (not my work)
Hope this helps someone else making the same silly error as me, and if anyone knows why specifying the entity makes such a difference let me know!
Hi, Hugh!
Thank you very much for your help! As you mentioned in the second point, I mistakenly ran a file compiled on Windows in UKB-RAP. Now the program is running smoothly! Thanks again for your assistance!
Please sign in to leave a comment.