ETL to Dataset marcia hon  2018-02-16 09:58
Status: Closed
 
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
Hi Marcia,

Is there any reason why you're choosing to use an ETL to copy the Assay Data over to a Dataset rather than using the Copy-To-Study function?

If you want to publish your assay data to your study, using a Copy-To-Study is a better option:

https://www.labkey.org/Documentation/wiki-page.view?name=publishAssayData

Regards,

Jon
 
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!