Expand Well Position

This node takes a string column containing well positions (like B3 or C14) and appends two columns named 'plateRow' and 'plateColumn'. It handles well positions up to 1536 plate format.

The output column 'plateRow' will either contain the letter or the numeric representation (depending on the node settings). The output column 'plateColumn' will contain the number of the plate column.

Options

Well Position: The column which contains well positions encoded as B3 or C14
Convert Row Characters: If enabled, the row character (e.g. B or C) will be converted automatically into a row number (e.g. 2 or 3)
Delete Source Column: If enabled, the selected column will be removed.

Input Ports

: Input table with well column

Output Ports

: Input table with expanded well position.

Popular Predecessors

Excel Reader12 %
Expand Well Position7 %
String Manipulation7 %
CSV Reader7 %
Joiner6 %
Row Filter4 %
GroupBy4 %
Constant Value Column4 %
Column Rename4 %
Create Well Position4 %
Concatenate4 %
Column Filter4 %
RowID4 %
File Reader4 %
Loop End4 %
Column Renamer4 %
Sorter2 %
Rule Engine2 %
CSV Reader2 %
Cell Splitter1 %
Pivoting1 %
Column Merger1 %
Expand Barcode< 1 %
File Reader< 1 %
Column Combiner< 1 %
Joiner< 1 %
Rule-based Row Filter< 1 %
Excel Reader (XLS)< 1 %
~~Regex Extractor~~< 1 %
Loop End< 1 %
Column Resorter< 1 %
Missing Value< 1 %
Column Splitter< 1 %
Math Formula< 1 %
Don't Save Start< 1 %

Popular Successors

Views

This node has no views

Workflows

Developers

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.

Installation

To use this node in KNIME, install the extension KNIME HCS Tools from the below update site following our NodePit Product and Node Installation Guide:

v5.12

Plugin provider: Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)

Plugin version: 5.5.0.v202511111303

On NodePit since: 2026-07-06

Last update: 2026-08-03

KNIME versions: v5.12, v5.11, v5.10, v5.9, v5.8, v5.7, v5.6, v5.5, v5.4, v5.3, v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2, v4.1, v4.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!