Icon

sqlite_​type_​mapping_​problem_​03

It gives standard_value column as integer: value of activity_id = 31906 is truncated (0.18 -> 0). Possible data corruption!
It gives standard_value column as string: value of activity_id = 31906 is 0.18
Suggested by mlauber71
gives standard_valuecolumn as integer
DB Query Reader
setting the generic mapping to:NUMERIC -> Double -> Number (Float)doesn't solve the issue
DB Query Reader
extracted standard_activitydata spec = "NUMERIC"
DB Data Spec Extractor
extracted standard_activitydata spec = "NUMERIC"
DB Data Spec Extractor
gives standard_valuecolumn as string
DB Query Reader
setting the specific column mapping to:NUMERIC -> Double -> Number (Float)doesn't solve the issue
DB Query Reader
select activity_id = 31906
Row Filter
same query asDB Query Reader
DB Table Selector
connect to ChEMBL_V36SQLite databasedownloadable from:https://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/releases/chembl_36/chembl_36_sqlite.tar.gz
SQLite Connector
same query asDB Query Reader
DB Table Selector

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: giovannicincilla
Created at: 2026-01-05
On NodePit since: 2026-01-09
Last update: 2026-01-10
Created with KNIME version: v5.8.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!