I use routinely Query Builder to output files from a database but get into problems because they all have the same name ( apart from a (1), (2) etc after the name and so I then have go manually go and alter the name to match the experiment the data comes from.
How would I run a script to alter the name to match a certain column or columns in the data table?
So in the attached example I want to change the name from "Experiment Characterisation Results" to "5387_Experiment Name_Experiment Characterisation Results". With the extra bits of the names coming from the data table associated with it.
Here is a simple script that will do what you want
Name Defaults to Here( 1 );
dt = current data table();
dt << set name(Char(dt:experiment_id) || "_" || dt:Experiment Plan Name || "_Experiment Characterization Results");
dt = current data table ();
name = dt:Experiment Plan Name;
sample = dt:Sample Name;
dt << set name (char(id)||"_Experiment Name_"||char(name)||" "||char(sample));