Icon

table_​diff_​to_​csv

Get owner and table name Create sql Diff and persist Get reference data Node 2ALL_TABLES$owner__table_nameProd $table_nameNode 4Node 15Node 3ALL_CONSTRAINTSremove unusedNode 25Node 30ALL_CONS_COLUMNSremove unusedNode 33Node 34Node 35Node 40Node 41Node 43Node 44order by column listorder by clausesqlNode 49Node 2Prod/IntValuesSpecsProd/Int ValuesProd/Int SpecsSpecsValues DB Reader DB Table Selector Table Row ToVariable Loop Start DB Table Selector Table DifferenceFinder DB Reader DB Reader DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Table Selector DB Column Filter DB Joiner DB Sorter DB Column Filter DB Query Extractor DB Query Injector Table Rowto Variable GroupBy DB Reader String Manipulation(Variable) String Manipulation(Variable) Column Filter DB Query Injector Variable Loop End CSV Writer CSV Writer String Manipulation(Variable) String Manipulation(Variable) String to Path(Variable) String to Path(Variable) Get owner and table name Create sql Diff and persist Get reference data Node 2ALL_TABLES$owner__table_nameProd $table_nameNode 4Node 15Node 3ALL_CONSTRAINTSremove unusedNode 25Node 30ALL_CONS_COLUMNSremove unusedNode 33Node 34Node 35Node 40Node 41Node 43Node 44order by column listorder by clausesqlNode 49Node 2Prod/IntValuesSpecsProd/Int ValuesProd/Int SpecsSpecsValuesDB Reader DB Table Selector Table Row ToVariable Loop Start DB Table Selector Table DifferenceFinder DB Reader DB Reader DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Table Selector DB Column Filter DB Joiner DB Sorter DB Column Filter DB Query Extractor DB Query Injector Table Rowto Variable GroupBy DB Reader String Manipulation(Variable) String Manipulation(Variable) Column Filter DB Query Injector Variable Loop End CSV Writer CSV Writer String Manipulation(Variable) String Manipulation(Variable) String to Path(Variable) String to Path(Variable)

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: kellnerthi
Created at: 2023-03-15
On NodePit since: 2023-03-15
Last update: 2024-04-26
Created with KNIME version: v4.7.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!