Transformation Scripts

LabKey Support Forum
Transformation Scripts marcia hon  2018-04-19 08:08
Status: Closed
 

Hello,

I have an assay: assay.general.nrg_assay .

How do I reference this assay in the transformation scripts?

In the ETL structure, where do I put this scirpt?

Is it supposed to be ../queries/assay/general/nrg_assay.sql?

Thanks,
Marcia

 
 
Jon (LabKey DevOps) responded:  2018-04-20 12:28
Hi Marcia,

I'm not understanding your question here.

Transformation Scripts cannot be in SQL. They are either in Perl, Java, R, or Python as explained here:

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

ETLs also have no direct relation to assays as well, unless your module is doubling both as an ETL module and an Assay module (https://www.labkey.org/Documentation/wiki-page.view?name=moduleassay), which if you're talking about an Assay module, transformation scripts would have to be dictated in the config.xml file for the Assay module and using the transformation scripts XML tag - https://www.labkey.org/download/schema-docs/xml-schemas/schemas/assayProvider_xsd/elements/transformScript.html

Can you in full detail explain what you're working on in full? If we can get a full detailed description of what you're working on and what you're trying to accomplish here, we can provide you with a better and more thought out answer.

Regards,

Jon