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?