Icon

kn_​forum_​44798_​database_​long_​value

convert Long value to string to use it in DB query (forum 44798)
convert Long value to string to use it in DB query (forum 44798) in memory202207071728562022070817285620220709172856transfer to tablemy_table=> adapt batch sizeDROP VIEW IF EXISTS "PUBLIC"."my_table";DROP TABLE IF EXISTS "PUBLIC"."my_table";create table my_tableMaximumSELECT * FROM #table# AS "table"WHERE "var_long" = $${SMax*(var_long)}$$SELECT * FROM "PUBLIC"."my_table"WHERE "var_long" = $${SMax*(var_long)}$$Max*(var_long)Max*(var_long)H2 Connector Table Creator DB Writer DB SQL Executor DB Table Creator GroupBy DB Query DB Query Reader DB Reader Table Rowto Variable Number To String convert Long value to string to use it in DB query (forum 44798) in memory202207071728562022070817285620220709172856transfer to tablemy_table=> adapt batch sizeDROP VIEW IF EXISTS "PUBLIC"."my_table";DROP TABLE IF EXISTS "PUBLIC"."my_table";create tablemy_tableMaximumSELECT * FROM #table# AS "table"WHERE "var_long" = $${SMax*(var_long)}$$SELECT * FROM "PUBLIC"."my_table"WHERE "var_long" = $${SMax*(var_long)}$$Max*(var_long)Max*(var_long)H2 Connector Table Creator DB Writer DB SQL Executor DB Table Creator GroupBy DB Query DB Query Reader DB Reader Table Rowto Variable Number To String

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: A9699459
Created at: 2022-07-07
On NodePit since: 2022-07-08
Last update: 2024-05-01
Created with KNIME version: v4.5.2
Tags: dbdatabaselongintegervariableh2sql

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

Try NodePit Runner!