I´m accessing a MS SQL Database with the DB Connector and DB Query Reader. Evrythink works fine, but for certain fields KNIME prints ? for Missing value, even though the database cell has a value present (confirment with different tools).
The database cell is a nvarchar 30 and the mapping in KNIME is String. Other columns with varchar 200 or something else are displayed. The problem occures with different columns, but I can’t seem a pattern.
I didn’t alter the input mapping.
because there is just one row that is hit, when I exculude the missing values in the where clausel, I get no results. The order by statement (for MSSQL its “ORDER BY ISNULL(Serial, 1), Serial DESC”) makes no difference.
The funny thing is, that this problem is not consitant. Other columns (same data type) don’t have the same problem…