Search site

demo
Found 24 results
Displaying page 1 of 2

Linking between custom tables

Hello, I have table_a with column "participant" and table_b with column "participant". I would like for these columns to be linked. I know I can do foreign/primary key. In the attached screenshot, I would like the Participantid to link both tables. In my second screenshot, this is what I would like to have. A location with all the links. I look forward to your expertise. Thanks, Hi Marcia,...

How to create "New Study with pre-defined timepoints"

https://www.labkey.org/wiki/home/Documentation/page.view?name=setUpDatasets I am trying to set up a new "Study" and am having some issues as below, can someone help please? For the "Demographics" file instead of having a start date I have predefined time points so instead of the following: 101344    2008-04-27    2008-04-27    Germany    English    f    ARV    Group 1: Acute HIV-1       ...

cohorts.xml

101344 103505 103866 107201 119180 120043 121933 125478 133428 140163 150489 150817 151224 154864 155805 160386 165074 166726 167572 172476 174815 175603 185014 186899 191927 209005 211137 213932 220376 226423 234482 237773 246655...

Cd4 vs Viral Load.db_35.report.xml

false timeChartReportDescriptor Cd4 vs Viral Load 12.31 ReportService.TimeChartReport {"chartLayout":"per_subject","chartSubjectSelection":"subjects","displayIndividual":true,"displayAggregate":false,"aggregateType":"Mean","errorBars":"None","lineWidth":2,"hideDataPoints":true,"pointClickFn":null,"title":"Lab Results, HIV Test Results","measures":[{"measure":{"id":4,"name":"CD4","label":"CD4+...

Mean Cohort Lymph Levels.db_43.report.xml

Reports false timeChartReportDescriptor Mean Cohort Lymph Levels 11.22 ReportService.TimeChartReport {"chartLayout":"single","chartSubjectSelection":"groups","displayIndividual":false,"displayAggregate":true,"aggregateType":"Mean","errorBars":"None","lineWidth":2,"hideDataPoints":false,"pointClickFn":null,"title":"Lab Results","measures":[{"measure":{"id":31,"name":"Lymphocytes","label":"Lymphs...

Lab Results - Mean CD4+ Count.db_40.report.xml

false timeChartReportDescriptor Lab Results - Mean CD4+ Count 13.3 ReportService.TimeChartReport {"chartLayout":"single","chartSubjectSelection":"groups","displayIndividual":false,"displayAggregate":true,"aggregateType":"Mean","errorBars":"None","lineWidth":3,"hideDataPoints":false,"pointClickFn":null,"title":"Lab Results - Mean CD4+ Count","measures":[{"measure":{"id":63,"name":"CD4","label":"CD4+...

Average CD4+ Levels Per Cohort.db_33.report.xml

Reports false timeChartReportDescriptor Average CD4+ Levels Per Cohort 12.1 ReportService.TimeChartReport {"chartLayout":"single","chartSubjectSelection":"groups","displayIndividual":false,"displayAggregate":true,"aggregateType":"Mean","errorBars":"None","lineWidth":3,"hideDataPoints":false,"pointClickFn":null,"title":"Average CD4+ Levels Per Cohort","measures":[{"measure":{"id":18,"name":"CD4","label":"CD4+...

Lymphocyte Count_ Disease Progression without ARV.db_41.report.xml

Reports false timeChartReportDescriptor Lymphocyte Count: Disease Progression without ARV 12.2 ReportService.TimeChartReport {"chartLayout":"single","chartSubjectSelection":"groups","displayIndividual":false,"displayAggregate":true,"aggregateType":"Mean","errorBars":"None","lineWidth":3,"hideDataPoints":false,"pointClickFn":null,"title":"Lab Results","measures":[{"measure":{"id":48,"name":"Lymphocytes","label":"Lymphs...

How is Study Data Stored in LabKey Server?

This topic answers a few questions about how study data is stored inside the server: When you create a study dataset and import data to it, how is that data stored and managed in the system? How is data from different studies related? Is the data from different studies physically or logically separated? Topics Data Tables within Schema Import Process System Tables Visit Labels Data Integration...

participant_groups.xml

103866 110349 120043 121933 125478 133428 144740 150489 155805 174815 175603 185014 209005 211137 213932 219304 237773 249318596 249325717 266626 278889 293749 296663 298529 303553 309880 338626...

HIV Disease Progression - Demo Study-ViralLoad (NASBA Method)-2019-04-11-0936.tsv

Participant ID Date Day ViralLoad (NASBA Method) Treatment Group ARVRegime Type 101344 39568 3 100 ARV ETR 101344 39596 31 193324 ARV ETR 101344 39624 59 59582 ARV ETR 101344 39652 87 702 ARV ETR 101344 39680 115 309 ARV ETR 101344 39708 143 720 ARV ETR 101344 39736 171 287 ARV ETR 101344 39764 199 183 ARV ETR 101344 39792 227 149 ARV ETR 101344 39820 255 99 ARV ETR 101344 39848 283 1980 ARV ETR 101344...

Physical Exam.xls

data Participant ID Date Height (cm) Weight (kg) Temperature (C) Systolic Blood Pressure xxx/ Diastolic Blood Pressure /xxx Pulse Respirations Clinician Signature/Date Pregnancy Form Language ARV? ARV Regimen Type 101344 2008-04-27 173.0000 68 37.0 117 83 61 101344 2008-05-25 175.0000 69 36.8 145 103 71 101344 2008-06-22 175.0000 71 38.2 166 101 68 101344 2008-08-17 173.0000 73 36.5 125 95 74...

HIV Disease Progression - Demo Study-ViralLoad (NASBA Method)-2019-04-11-0937.tsv

Participant ID Date Day ViralLoad (NASBA Method) Treatment Group ARVRegime Type 101344 4/30/2008 3 100 ARV ETR 101344 5/28/2008 31 193324 ARV ETR 101344 6/25/2008 59 59582 ARV ETR 101344 7/23/2008 87 702 ARV ETR 101344 8/20/2008 115 309 ARV ETR 101344 9/17/2008 143 720 ARV ETR 101344 10/15/2008 171 287 ARV ETR 101344 11/12/2008 199 183 ARV ETR 101344 12/10/2008 227 149 ARV ETR 101344 1/7/2009 255...

dataset5004.tsv

ParticipantId date QCStateLabel Weight_kg Temp_C SystolicBloodPressure DiastolicBloodPressure Pulse Respirations Signature Pregnancy Language ARV ARVtype height_cm 101344 2008-04-27 00:00:00.0 68 37.0 117 83 61 173.0 101344 2008-05-25 00:00:00.0 69 36.8 145 103 71 175.0 101344 2008-06-22 00:00:00.0 71 38.2 166 101 68 175.0 101344 2008-08-17 00:00:00.0 73 36.5 125 95 74 ...

Demographics.xls

data Participant ID Date Start Date Height (inches) Gender Country Group Assignment Status of Infection Comments Treatment Group 101344 2008-04-27 2008-04-27 f 103505 2008-04-24 2008-04-24 f 103866 2008-04-21 2008-04-21 69 m USA Group 1: Acute HIV-1 Natural Controller 107201 2008-05-22 2008-05-22 f 110349 2008-04-28 2008-04-28 62 m USA Group 2: HIV-1 Negative 119180 2008-04-20 2008-04-20...

Interactive Example - Study-MedicalHistory-2019-04-09-1616.tsv

Participant ID Date city state zip DOB PrimaryCarePhysician LastMedicalExam LastEyeDoctor LastEyeExam ContactByEmail Phone Occupation DrugAllergy CurrentMedication Married 101344 2008-04-27 Sparks NV 89436 3/15/1963 Upton Hundall 7/4/1969 3/16/1969 2/8/1972 FALSE 775-643-7120 Senior Developer Miconazole Nitrate Willow Fern TRUE 103505 2008-04-24 Lakeland FL 33811 11/19/1959 Alicia Grunson 5/11/1989...

Interactive Example - Study-Medical History-2019-04-09-1614.tsv

Participant ID Date city state zip DOB PrimaryCarePhysician LastMedicalExam LastEyeDoctor LastEyeExam ContactByEmail Phone Occupation DrugAllergy CurrentMedication Married 101344 2008-04-27 Sparks NV 89436 3/15/1963 Upton Hundall 7/4/1969 3/16/1969 2/8/1972 FALSE 775-643-7120 Senior Developer Miconazole Nitrate Willow Fern TRUE 103505 2008-04-24 Lakeland FL 33811 11/19/1959 Alicia Grunson 5/11/1989...

dataset5007.tsv

ParticipantId date QCStateLabel CD4 Lymphocytes Hemoglobin ViralLoad 101344 2008-04-30 00:00:00.0 811 1491 14.0 101344 2008-05-28 00:00:00.0 794 1446 13.0 101344 2008-06-25 00:00:00.0 653 1560 12.0 101344 2008-07-23 00:00:00.0 1176 1486 11.0 101344 2008-08-20 00:00:00.0 1292 1343 11.0 101344 2008-09-17 00:00:00.0 1210 1186 12.0 101344 2008-10-15 00:00:00.0 1158 1320 13.0 101344 2008-11-12...