Add "0" in front of one digit string

KNIME Analytics Platform
5

Hi @namankumar169,

I am not sure what causes your error. It might be an invalid input, you would need to give us some more information, maybe you can post the workflow?

However, another easy way to solve this task is using the Column Expressions node with this script:

if (length(column("column1"))<2) {
    "0" + column("column1")
} else {
    column("column1")
}

column1 must be replaced by your column name. Here is also an example workflow:add_leading_0.knwf (6.2 KB)

Cheers,
Simon

6 Likes