ETL Store Procedure: /home/Support/LabKey Support Forum

ETL Store Procedure

LabKey Support Forum (Inactive)

View Message

ETL Store Procedure

hilariagrieve

2016-10-24 04:10

Status: Closed

Hi!
I am trying to make a dataset with finals results.
I have a general assay, "Secuenciación ABI" that using a script loads the secuencing data (like the file I attached called "secuenciación.png")
Here, each raw has the results for a specific marker (Marker:D10S1248/Alele1:13/Alelle2:14).

So what I want to do, is make a datasets called "Perfiles Genéticos" that joins all the information for one SpecimenID and ParticipantID, like the second file I attached "perfilesgeneticos.png".

Can I do this with ETL Module? o what do you suggest me?

I don't know how.
Thanks for your help.

Regards,
Hilaria

secuenciacion.png

perfilesgeneticos.png

Jon (LabKey DevOps) responded:	2016-10-26 22:27
Hi Hilaria, It sounds like what you're needing isn't an ETL, but a PIVOT query to be done on the data. Have you reviewed our PIVOT docs? It should give you the desired results you're seeking if I'm understanding you correctly. https://www.labkey.org/home/Documentation/wiki-page.view?name=pivot Regards, Jon

hilariagrieve responded:	2016-11-02 06:44
Hi Jon! I am goint to see if I can join the data with PIVOT query, but I think that I will need to have a dataset with this information loaded and related with participants id, to access it if I need. Thanks!