Hub
Pricing About
NodeNode / Manipulator

Join Layout

Community NodesHCS ToolsUtilities
Drag & drop
Like

The node is dedicated to ease the processing of microscope or plate reader data. It annotates meta information and/or layout data by a certain position in the plate. The meta information is provided by an Excel sheet which follows a specific formatting. The sheet can contain different layers of information (e.g. compound name, compound concentration, ...).

The first layer has to start at C5 in the Excel sheet. This position contains the layer name (used as column names in the output table).The next row (starting at D6) contains the plate column numbers (1,2,3,...), while column 5 (starting at C7) contains the plate row identifier (A,B,C,... or 1,2,3,...). The dimensions are limited to 1536 well format (32 rows, 48 columns). Dimensions have to be the same for all layers. Within the area defined by plate row and column identifiers cells can contain metainformation of different data types (string, double, integer) or left empty.
The next layer starts again with its name in column C with a gap of 2 rows to the previous layer. Each layer will result in a new column of the output table.
The input table has to provide two numeric columns representing the well position (plate row and plate column). See 'Plate Row Converter' node to convert row identifiers (A,B,C,...) to its integer representation.
For a screen shot and a download of an example file look here: HCS-Tools Wiki

Node details

Input ports
  1. Type: Table
    plate data
    Table contains microscope or plate reader data
Output ports
  1. Type: Table
    annotated plate data
    Input table extended by a certain number of meta data columns

Extension

The Join Layout node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits