Hello,
I have an ETL module. It gets data from an assay and then uploads it to a dataset.
The problem is that it is making the combination of ParticipantID and VisitID as a key. Therefore, I cannot upload more of this combination.
My understanding, is that this should be possible.
A solution that I'm thinking of, is to make all columns together as the primary key. Please could you let me know how to specify what belongs to a primary key?
I look forward to your feedback.
Thanks,
Marcia |
|
Jon (LabKey DevOps) responded: |
2018-02-16 22:23 |
|
|
marcia hon responded: |
2018-02-17 09:35 |
I have 3 assays that I would like to copy to one dataset.
I tried copy-to-study, but this only copies to a study that has the same exact name as the assay.
is there are work around? |
|
Jon (LabKey DevOps) responded: |
2018-02-19 22:53 |
Hi Marcia,
That is a little odd to have three separate assays to copy to one dataset.
Is there any reason why you're choosing to have multiple assays of what is the same information, but only one study (and one dataset) for those three assays?
Regards,
Jon |
|
marcia hon responded: |
2018-02-21 06:09 |
I found an alternative solution.
I have three assays.
I copy them to datasets.
Then I do a query that does a "union" of all the datasets.
Thanks for your help! |
|
|
|