Icon

Create a Rank variable with leading zeros - KNIME Forum (77507)

Create a Rank variable with leading zeros 0001, 0002 ....

https://forum.knime.com/t/creating-unique-item-codes-on-a-running-file/77507/5?u=mlauber71

With new nodes KNIME 5.8+
rank_length
Table Row to Variable
RowID
Rank
highest numberof rank
Row Filter
highest numberof rank
Row Filter (deprecated)
PMML Transformation Apply
convert rankto string
Number to String (PMML)
rank_length
Expression
Data Generator
sort by highest RankDESCENDING
Sorter
sort by highest RankDESCENDING
Sorter
convert rankto string
Number to String (PMML)
PMML Transformation Apply
RowID
rank_lengthlength(strip(column("rank")))
Column Expressions (legacy)
rank_length
Table Row to Variable
padLeft(column("rank"),variable("rank_lenth") , "0")
Column Expressions (legacy)
pad_start($["rank"],$$["rank_length"],"0")
Expression

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2024-02-28
On NodePit since: 2024-03-05
Last update: 2025-11-03
Created with KNIME version: v5.8.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!