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"

Check Duplication

Usage Instructions:

First go to CONFIG and Define the Year, Cycle and Environment.

On the Check Duplication. It should only exist one case that is Bangalore IN-BAN-009 because the SCML is not equal in all the properties.

The "Workaround to define the classification" shouldn't have any records, but it was added just in case.

Execute the flow.

NOTE: If any of the parallel processes terminate with disconnected error, relaunch that node. If other error you need to investigate.

TODO: Replace snowflake account with the Service account, when the SA it's ready to connect to snowflake.

Performance evaluator

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
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
CONFIG
Data Inputs
Rename NAM -> NA
Expression
Table View
Exclude missing Building_IDand Skillman lands
Rule-based Row Filter

Nodes

Extensions

Links