Unknown column

Hi, i'm reading an xls file.

Sometimes a column is empty and it is marked as Unknown column. How can i fill this column with 0 values? The Missing Value Node and the Java Snippet Node seem to be useless.


I think you can use the Java Snippet (simple) using return 0; as statement and replace this column with column type "Integer".

Hi, thanks for the reply. I have resolved with StringToNumber. This node automatically convert any unknow column.