DSM data testing: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (m) |
Ttenbergen (talk | contribs) m (m) |
||
Line 2: | Line 2: | ||
# open DSM_Labs_Consistency_check | # open DSM_Labs_Consistency_check | ||
# import data into table Trial_export (field testresult must be memo; access file needs to be well under 2GB or error) | # import data into a new table "Trial_export" (import into existing table goes wrong it seems, field testresult must be memo; access file needs to be well under 2GB or error) | ||
# run query 1_requester_maker to populate Labs_requester; too slow to do with query | |||
# run query 2_labs_reformed_maker to deal with date formats and to split out MRNs etc | |||
[[Category:Labs]] | [[Category:Labs]] |
Revision as of 15:29, 2014 December 29
currently in "DSM labs comparison" on Tina's desktop
- open DSM_Labs_Consistency_check
- import data into a new table "Trial_export" (import into existing table goes wrong it seems, field testresult must be memo; access file needs to be well under 2GB or error)
- run query 1_requester_maker to populate Labs_requester; too slow to do with query
- run query 2_labs_reformed_maker to deal with date formats and to split out MRNs etc