Icon

Demo SqlLite Count as String issue - with workaround

Demo SqlLite Count as String issue

Demonstration of SqlLite database count being returned as String

Workarond: Set Input type mapping DatabaseSample DataPopulate Album tableCreate Album tableAlbum tableCount returned as StringCount returned as StringAlbum table custom querycast as integerAlbum table custom queryCount returned as StringCount returned as IntegerClear down Album tableif re-executingAlbum table custom querycast as integer butcolumn renamedCount returned as stringAlbum tableWith manually defined TYPE MAPPING for COUNT.* columnsCount returned as IntegerCount returned as IntegerSQLite Connector Table Creator DB Insert DB Table Creator DB Table Selector DB GroupBy DB Reader DB Table Selector DB Table Selector DB Reader DB Reader DB SQL Executor DB Table Selector DB Reader DB Table Selector DB GroupBy DB Reader Workarond: Set Input type mapping DatabaseSample DataPopulate Album tableCreate Album tableAlbum tableCount returned as StringCount returned as StringAlbum table custom querycast as integerAlbum table custom queryCount returned as StringCount returned as IntegerClear down Album tableif re-executingAlbum table custom querycast as integer butcolumn renamedCount returned as stringAlbum tableWith manually defined TYPE MAPPING for COUNT.* columnsCount returned as IntegerCount returned as IntegerSQLite Connector Table Creator DB Insert DB Table Creator DB Table Selector DB GroupBy DB Reader DB Table Selector DB Table Selector DB Reader DB Reader DB SQL Executor DB Table Selector DB Reader DB Table Selector DB GroupBy DB Reader

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: BATEB031
Created at: 2023-04-28
On NodePit since: 2023-04-29
Last update: 2024-05-02
Created with KNIME version: v4.6.4

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

Try NodePit Runner!