Data Creator

Define a new data set with organism, matrix, assay conditions and references. There are three ways to enter your own laboratory data:

1) Time series and concentrations can be copied (e.g. from CSV files) and pasted into the table,
2) they can be imported via an XLS file or
3) they can be entered manually. In the latter case the setting of equidistant time steps accelerates entering a time series.


Click on the '+' symbol to choose one or more references from the internal database. To add new a reference to the database, exit this node dialog, go to the Knime menu 'PMM-Lab', select 'Open DB GUI...' and select the references table.
References can be either imported as *.ris or *.txt file via the table import (Ctrl+F1) or they can be entered manually by clicking the green '+' button in the database.

Experimental conditions
Organism and Matrix: Click the 'Select' button to get to the correspondent database tables and assign the appropriate entries.
ID: The ID can be a number or a character or a combination (e.g. 'Table A.1'). If no ID is given, PMM-Lab will create a negative 10-digit number as ID.
Comment: Any string as comment to the experimental conditions.
Time: Choose the time unit for the time series. These are d (day), wk (week), s (second), min (minute), h (hour), mo (month) and a (year).
Value: Assign the unit to your values. In case of bacterial concentrations this might be 'count/g' (cfu/g); for other datasets '%' or 'ppm' might be more appropriate.
Temperature: Type in the temperature value of your time series and define in which temperature scale it was measured.
pH and aw: pH and water activity do not have a unit.
Additional experimental conditions: For more experimental conditions click the '+' buttton and choose other parameters from the database (e.g. 'acetic acid' or 'pressure').
Table: Time and Value
There are three ways to enter microbial data:

1) Type time and concentration manually. To navigate use Tab and Enter or the arrow keys.
If the time steps always have the same step size the button 'Set equidistant time steps' can help. Define the 'number of time steps' and the 'step size'. Example: If the number of time steps is 4 and the step size is 15 you will create the time series '15, 30, 45, 60'.

2) Copy and paste: Open a spreadsheet, copy the appropriate columns and paste them in the Microbial Data Creator by clicking one cell in the time column and pressing Ctrl+V. This is especially useful if an experiment was done in replicates and the time series starts several times anew from 0.

3) Read from XLS file: Import microbial data from a Microsoft Excel spreadsheet.The table should at least have olumns for ID, time and value (value: e.g. log10(cfu/g)). Without an ID no time series can be imported. Every Excel column needs a headline (the first row). Rows with the same ID belong to one time series.
Open the path to the XLS file, select the Excel sheet and assign columns to ID, time and value. If the spreadsheet also contains columns for temperature, pH, aw and a comment, these can also be assigned, here. Otherwise, they can be assigned as stated under 'Experimental conditions'.

To delete the whole table click 'Clear'.

Input Ports

This node has no input ports

Output Ports

Created data

Popular Predecessors

  • No recommendations found


This node has no views


  • No workflows found



You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.