I am working with other tables. I am using several fields of the assay data to do a lookup (including joins) and if a value is not found, do an insert, returning the new id. If this sounds like something I could do with a trigger please let me know, but from my understanding I don't think it can be done.

I just figured out that I can use core java libraries in my js transform script using this syntax:

var File = Packages.java.io.File

Is it possible to include packages from .jar files? I am hoping for a way to parse the .tsv file into a data structure that is more robust than just splitting each line.