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.
Could you please send us the configuration (input dialog), of the mapping part. Also screenshots of the problem may help us to find out what could be the problem.
I´m not that new, but thanks for welcoming me again nevertheless
Here are the configuration: The DB-Connector Node -Connection Settings
(diffent Dialect makes no difference):
The DB-Connector Node -Input Mapping (all Default)
@goodvirus have you considered excluding missings? And maybe add an ORDER statement where you put something like “ORDER BY xyz DESCENDING MISSINGS LAST” (might depend on your SQL dialect).
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…
