Icon

KNIME_​AI project offset 2_​Kenny

Node 41Node 43TGBI_R onlyBuilding Key InformationNode 76Node 77SQL queryNode 91SQL queryby appliance, age countreplacement rateCC locationsNode 215Node 217Node 218Node 219Node 220Filter Rank#1SouthernNode 234Filter out SouthernNode 236CENTRAL AND WESTERNNode 238Node 239filter out Aberdeen0014508Node 242Node 243filter out AberdeenNode 2460014508Node 2480014508Area = Tsing YiNode 265Node 266Area = Tsing YiNode 270Area = Tsing YiArea = Tsing YiFilter Rank#1Node 274Node 275Area = Tsing YiNode 279Node 280Filter Rank#1Area = Tsing YiNode 283Node 412CITY = LANTAUNode 414CITY = LANTAUNode 416Node 417Node 418Node 419Node 420Node 421Node 422Node 423Node 424Node 428replacement by buildingNode 430Node 431replacementFilter by buildingNode 434replacement by buildingreplacement by buildingNode 437Node 438Node 439Node 440Excel for Kennyby appliance, age countNode 443SQL 2017-2019SQL queryNode 446replacement by buildingNode 448Node 449Get_all_tables_with_SQL_sample Amazon AthenaConnector (legacy) Row Filter Excel Reader (XLS) Math Formula Column Filter Database Reader(legacy) Pivoting Database Reader(legacy) GroupBy Excel Reader (XLS) Excel Reader (XLS) Variable toTable Column Table Row ToVariable Loop Start Loop End Column Rename Rank Row Filter Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Row Filter Row Filter Rank Concatenate Row Filter Row Filter Rank Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Row Filter Concatenate GroupBy Joiner Joiner Double To Int GroupBy GroupBy String To Number Joiner GroupBy GroupBy Row Filter GroupBy GroupBy Row Filter GroupBy GroupBy GroupBy Row Filter GroupBy Joiner GroupBy Excel Writer (XLS) GroupBy Amazon AthenaConnector (legacy) Database Reader(legacy) Database Reader(legacy) Joiner GroupBy Rule Engine Rule Engine Node 41Node 43TGBI_R onlyBuilding Key InformationNode 76Node 77SQL queryNode 91SQL queryby appliance, age countreplacement rateCC locationsNode 215Node 217Node 218Node 219Node 220Filter Rank#1SouthernNode 234Filter out SouthernNode 236CENTRAL AND WESTERNNode 238Node 239filter out Aberdeen0014508Node 242Node 243filter out AberdeenNode 2460014508Node 2480014508Area = Tsing YiNode 265Node 266Area = Tsing YiNode 270Area = Tsing YiArea = Tsing YiFilter Rank#1Node 274Node 275Area = Tsing YiNode 279Node 280Filter Rank#1Area = Tsing YiNode 283Node 412CITY = LANTAUNode 414CITY = LANTAUNode 416Node 417Node 418Node 419Node 420Node 421Node 422Node 423Node 424Node 428replacement by buildingNode 430Node 431replacementFilter by buildingNode 434replacement by buildingreplacement by buildingNode 437Node 438Node 439Node 440Excel for Kennyby appliance, age countNode 443SQL 2017-2019SQL queryNode 446replacement by buildingNode 448Node 449Get_all_tables_with_SQL_sample Amazon AthenaConnector (legacy) Row Filter Excel Reader (XLS) Math Formula Column Filter Database Reader(legacy) Pivoting Database Reader(legacy) GroupBy Excel Reader (XLS) Excel Reader (XLS) Variable toTable Column Table Row ToVariable Loop Start Loop End Column Rename Rank Row Filter Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Row Filter Row Filter Rank Concatenate Row Filter Row Filter Rank Row Filter Row Filter Concatenate Row Filter Row Filter Row Filter Row Filter Concatenate GroupBy Joiner Joiner Double To Int GroupBy GroupBy String To Number Joiner GroupBy GroupBy Row Filter GroupBy GroupBy Row Filter GroupBy GroupBy GroupBy Row Filter GroupBy Joiner GroupBy Excel Writer (XLS) GroupBy Amazon AthenaConnector (legacy) Database Reader(legacy) Database Reader(legacy) Joiner GroupBy Rule Engine Rule Engine

Nodes

Extensions

Links