Icon

kn_​forum_​34264_​aggregate_​data_​by_​id_​and_​merge

aggregate data by ID and merge

aggregate data by ID and merge


aggregate data by ID and merge Node 13filter campaign type knime://knime.workflow/data/h2_database.h2sample_00bigqueryNode 77data/bigquery.tableDROP TABLE IF EXISTS "PUBLIC"."bigquery";data/Detailed Process Metrics.tableaggregate by Campaign IDMaximum of Acted At$duplicate-type-classifier$ = "chosen" => TRUETRUE => FALSENode 86exclude missing IDsNode 88 String To Number Column Filter H2 Connector DB Writer DB Table Creator DB Reader Table Reader DB SQL Executor Table Reader DuplicateRow Filter Column Filter Rule-basedRow Filter Joiner Rule-basedRow Filter Joiner aggregate data by ID and merge Node 13filter campaign type knime://knime.workflow/data/h2_database.h2sample_00bigqueryNode 77data/bigquery.tableDROP TABLE IF EXISTS "PUBLIC"."bigquery";data/Detailed Process Metrics.tableaggregate by Campaign IDMaximum of Acted At$duplicate-type-classifier$ = "chosen" => TRUETRUE => FALSENode 86exclude missing IDsNode 88String To Number Column Filter H2 Connector DB Writer DB Table Creator DB Reader Table Reader DB SQL Executor Table Reader DuplicateRow Filter Column Filter Rule-basedRow Filter Joiner Rule-basedRow Filter Joiner

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: ADITRYA
Created at: 2021-06-27
On NodePit since: 2021-07-03
Last update: 2024-04-27
Created with KNIME version: v4.4.0

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

Try NodePit Runner!