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