WARN String to Number

KNIME Analytics Platform
1

image
image1076×685 149 KB

WARN Table Creator 3:175 Node created an empty data table.

WARN String to Number 3:195 Problems in 1324 rows, first error: “S” in cell [“RowKey_0_Row…”, column “Debit/Credit ind (SHKZG)”, row 1] can not be transformed into a number

RowID      |   ..   | Amount in L... | Debit/Credi... | Cost Center...

--------------------------------------------------------------------------

RowKey_0_Ro… | .. | 2034.0 | S | P0576855

                                      ^^^^^^^^^^^^^^^
2

Hey there,

not a lot to go on but from the screenshot you get an empty table after your Join operation (Node 3) and then String to Number cannot work and therefore throws a warning…

Suggest to use Empty Table Switch node to handle a scenario where the table is empty after the join operation

2 Likes