Icon

5YOP New cycle Records

Minhang Exception

Group CN-SHA-030, CN-SHA-031, CN-SHA-032, CN-SHA-033,

CN-SHA-034, CN-SHA-035 and CN-SHA-036

Workaround to define the classification when they come from Sequentra="N/A"

Individual execution (debug)

Check Building_IDduplication
Duplicate Row Filter
filter duplicated records
Expression Row Filter
Timer Info
Parallel Chunk End
Snowflake Connector
DB Table Selector
Parallel Chunks
RegionalInsert data into (SitesList, Site_Forecast,BVA_Forecast)
Python Script
Expression
DB Reader
Get Properties Data
DB Query
Placeholders and otherInsert data into (SitesList, Site_Forecast,BVA_Forecast)
Python Script
Concatenate
Duplicate sites withCommercial and Operations
One Row to Many
Prepare duplication of the sites with 2 classifications
Rule Engine
Set Classification
Expression
Segment Minhangfrom the rest of sites
Rule-based Row Splitter
GroupBy
Time of Execution of the flows
Expression
Select last if duplicated
Duplicate Row Filter
Column Renamer
Join all Sites
Concatenate
Building ID=CN-SHA-030
Expression
Concatenate
30 is the Commercial
Expression
Row Filter
Row Filter
Individual Site
Python Script
SitesInsert data into (SitesList, Site_Forecast,BVA_Forecast and Transact OPEX)
Python Script
Unify Column Names
Column Renamer
Sorter
Parallel Chunk Start
Table View
Row Splitter
NAM -> NA
Expression
Table View
Exclude missing Building_IDand Skillman lands
Rule-based Row Filter

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: HSilva01
Created at: 2025-10-30
On NodePit since: 2026-02-06
Last update: 2026-02-27
Created with KNIME version: v5.8.2

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

Try NodePit Runner!