Whether its experimental data, continuous process parameters, logbooks records, or a plate readout, the dataset feature allows you to continuously gather selected data in a structured manner.
Consolidating relevant data from various sources should be a seamless and natural process. With the Add to existing dataset function, externally sourced data can be incorporated into datasets, enhancing the flexibility of dataset editing and updating.
Before incorporating new data into an existing dataset, make sure that:
The data is in an XLSX file.
All dataset headers are located in the first row.
The column headers match those in the existing dataset you want to merge with (they are not case-sensitive)
Flow 1
Navigate to an experiment
Attach XLSX file
Add the attachments as a dataset
In the new pop-up, select from available compatible datasets
Please note that only datasets with identical headers will show up in the search
Flow 2
Navigate to the specific dataset you would like to add more data into
Press the 'Add to existing' button to import the XLSX file.
Import desired XLSX file
Notes:
The origin vector column will contain either the experiment name or the attachment name.
Incorporating more than one attachment with pre-existing datasets created from form elements is possible.
Removing rows added to the dataset from attachments can be done by deleting selected attachments from the experiment page or dataset page.
Refrain from having empty rows in the middle of the added file, as these would also be added to the dataset
Guru Tip
If you wish to join pre-existing attachments to an existing dataset from a page in Labguru that is signed or signed witnessed you have the option to download the attachment and use Flow #2 to add the data to desired dataset.
For more articles about datasets, see below: