CSV Writer is not retaining leading zeros.

KNIME Analytics Platform
1

Hi there KNIME community,

I am using a Column Expressions node to update a column of Employee ID’s so they are always 6 digits long. If shorter (1234), a leading zero is added (001234). This is working perfectly. I have adding an Excel Writer node after it, and it correctly retains the leading zeros. HOWEVER when I replace the Excel Writer node with the CSV Writer note, it removes the leading zero’s and reformats the data back to a number.

What am I doing wrong?

Thanks! :slight_smile:

2

Most likely conversion to number do the reading tool you use. If you use a transformation tab of CSV Reader and map ID to string you will see the leading zeros.

6 Likes