|Export data without lookup, remove all columns from grid view option||millerjw4||2019-10-08 08:10|
I was advised to submit support tickets by developers for the following items at the LabKey user conference, but I am unable to do this as I am a community user. I will post them here instead and hope they reach the right people.
Option to export data without lookups
Currently, when data using lookups in a LabKey grid view is exported to xlsx/tsv, the data is exported with the lookup value, and there is no option to recover the non-lookup value. It would be nice if this were made available as an option, as the script exports (R/Python/etc) export the raw data without lookup
Option to create a grid view starting with no columns
Currently, you have to base a new grid view on a dataset in the study schema, and if you are only interested in creating a report on a few columns (ie age/sex from demographics, measure 1 from instrument A), then it is a pain to have to remove all columns manually from whichever dataset you choose to base the view on.
It would be nice if there was an option to either:
Thank you for your help.