Hi,
I have defined some key-val pairs for a file( say Output.csv) in a
metout-config.xml for my PGETask Workflow. However, after executing the
workflow, the met-config.xml is not creating a Output.csv.cas file.
I want to be able to use the above keys/metadata later on in an SQL-like
query from the pgeconfig file. For example, if I've defined 'RecordID' as a
key in the metout-config.xml, I would want to use this metadata in the
following query:
SQL(FORMAT='$FileLocation/$Filename'){ SELECT
FileLocation,Filename,ISMTable,*RecordID* FROM ISMRawData WHERE ISMTable =
'Chartevents' AND *RecordID* = "PID"} The others keys included in the
query above are elements and product-types that were defined during
ingestion in the File Manager.
At present, the task fails to parse the above query when I run the workflow.
Is this because metout-config is not creating the Output.cas file? And,
what is the best way to specify metadata files for a group of files or for a
folder?
Thanks,
Sheryl
