Icon

KNIME_​installed analysis with prospect final weekly dashboard revised prospect_​24

Connect Access for knimeContractor commissionConcentrate the matching fieldsexport form knimeGrouping Qty by zonematching RS workzoneReplace workzoneFilterRevised Prospect Handler Employee No_SCRevised Sales Person Employee No_SCRevised missing commission codefilter rowsTableau_by office all yearNode 434Node 437Node 4432c One third prospect by RSNode 4532b Half Prospect by Prospect Office Code Node 50Node 463Node 4663 Appliance Installed by CentreNode 49Node 474Connect Access for appliance groupingrename columnNew WZ, PHE,SPERework Missing valueRead access fileRaw sheetrevised instance/ prospectNode 4992c One third prospect by RSWorkzoneNode 505Appliance Installed by work zone4b Half prospect by prospect employeeNode 508Node 509Node 512Prospect handlerTake out RSNode 515Node 517Node 518Node 519Node 520Node 521Node 522Node 5244a Appliance installed by employeecombining all employeeWorkzone4c One third prospect by work zoneNode 533Node 535Sales personTotal appliane sales by channelsRSHalf Prospect by work zoneNode 543Total appliane sales by employeeNode 545Node 547Node 549Node 550Node 552Node 554Node 556WorkzoneProspectNode 560Set missing as zeroNode 562Node 563Node 564Node 566Node 567Node 568Node 569Node 570Node 572Node 573Sales person indicatorSales person indicatorRevised sale indicatorNode 579Read EmployeeNode 582filter monthcheck by channelMonthlyreport of employee by appl type by monthNode 588Node 589Node 590Node 591Node 592Node 593revised instance/ prospectchecking the prospectchecking the prospectNode 601Node 602check missingemployeeRevised categoryfilter by monthTotal appliane sales by channelsTableau_by officereport of employee by monthTotal appliane sales by CC centrefilter RMSDTake out RSNode 614Node 615Node 616Tableau_by officeNode 618Node 619Node 620Total appliane sales by CC centrefilter monthSharan dashboardNode 624Node 625Node 626Node 627filter monthfilter monthfilter monthfilter monthfilter monthfilter monthNode 634Node 635Node 636Node 637Node 638Node 640Node 641Node 643Node 644filter monthNode 646Node 647Node 648Node 649filter monthNode 652filter monthNode 654Node 655Sharan dashboardBy groupingConnect Access for knimefilter monthTotal appliane sales by modelTotal appliane sales by employeeNode 664Take out RSMonthlyNode 670Node 671Node 672report of employee by monthTake out 0Take out 0Node 676Node 677Node 678Grouping Qty by zoneNode 680Grouping Qty by zoneGrouping Qty by zoneNode 683Node 684revised instance/ prospectNode 686Node 687filter RMSDNode 689Node 690Node 691Node 693Connect Access for appliance groupingRead sales_groupingNode 696Read sales_groupingNode 698report of Prospect matrix by monthchecking the prospectEmployee LIstNode 703Node 704Node 705filter rowsNode 707Node 708Node 709Node 710Node 711Prospect Pivot 1/2Node 713Prospect Pivot 1/3By groupingNode 716Node 717By groupingmodel filter monthRead Appliance groupingRead Appliance modelfilter monthTableau_by modelNode 726Node 727Node 728Node 730MR dashboardSharan dashboardmodel by monthNode 734Node 735Node 736Node 737revised instance/ prospectNode 739Node 740Microsoft AccessConnector DB Query Reader Column Aggregator Excel Writer (XLS)(deprecated) GroupBy Joiner (deprecated) Rule Engine GroupBy Rule Engine Rule Engine Rule Engine GroupBy Excel Writer (XLS)(deprecated) Math Formula GroupBy GroupBy Column Rename Math Formula Column Rename Math Formula Math Formula Concatenate Column Rename Math Formula Math Formula Microsoft AccessConnector Column Rename Java Snippet Missing Value Microsoft AccessConnector DB Query Reader Java Snippet Excel Writer (XLS)(deprecated) Column Rename GroupBy Math Formula Column Rename Column Rename Row Filter Math Formula Concatenate GroupBy Row Filter Math Formula Math Formula String Manipulation Joiner (deprecated) Concatenate Math Formula Math Formula Column Filter Math Formula Concatenate GroupBy Column Rename Concatenate Math Formula GroupBy GroupBy GroupBy Column Rename Math Formula GroupBy Concatenate Math Formula Math Formula String Manipulation Math Formula Rule Engine Row Filter GroupBy Math Formula Unpivoting Missing Value Column Rename Row Filter Row Filter Column Filter Column Filter Column Filter Column Filter Column Filter Math Formula Math Formula ConstantValue Column ConstantValue Column Rule Engine Joiner (deprecated) DB Query Reader Joiner (deprecated) Row Filter Row Filter Excel Writer (XLS)(deprecated) Concatenate Column Filter Column Rename Row Filter Row Filter Excel Writer (XLS)(deprecated) Java Snippet GroupBy GroupBy Row Filter Row Filter GroupBy Row Filter Row Filter GroupBy Excel Writer (XLS)(deprecated) Excel Writer (XLS)(deprecated) GroupBy Row Filter Row Filter GroupBy Row Filter Row Filter Excel Writer (XLS)(deprecated) Row Filter Row Filter GroupBy GroupBy Row Filter Excel Writer (XLS)(deprecated) GroupBy GroupBy GroupBy GroupBy Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Concatenate Concatenate Concatenate Concatenate GroupBy Joiner (deprecated) GroupBy String Replacer Joiner (deprecated) Row Filter Concatenate Column Filter(legacy) Column Filter(legacy) Rule Engine Row Filter Rule Engine Row Filter Concatenate Rule Engine Excel Writer (XLS)(deprecated) GroupBy Microsoft AccessConnector Row Filter GroupBy GroupBy GroupBy Row Filter Row Filter Column Filter Math Formula Row Filter Excel Writer (XLS)(deprecated) Row Filter Row Filter Row Filter String Replacer Rule Engine GroupBy Row Filter GroupBy GroupBy Row Filter Row Filter Java Snippet Row Filter Row Filter Row Filter Row Filter Excel Writer (XLS)(deprecated) Row Filter Rule Engine Microsoft AccessConnector DB Query Reader Joiner (deprecated) DB Query Reader Joiner (deprecated) Excel Writer (XLS)(deprecated) GroupBy Row Filter Rule Engine Rule Engine Math Formula GroupBy Row Filter Rule Engine Math Formula Row Filter GroupBy Pivoting Row Filter Pivoting GroupBy Joiner (deprecated) Joiner (deprecated) GroupBy Row Filter DB Query Reader DB Query Reader Row Filter Excel Writer (XLS)(deprecated) GroupBy Row Filter Joiner (deprecated) Row Filter Excel Writer (XLS)(deprecated) Excel Writer (XLS)(deprecated) Excel Writer (XLS)(deprecated) Row Filter GroupBy Row Filter Row Filter Java Snippet Excel Writer Row Filter Connect Access for knimeContractor commissionConcentrate the matching fieldsexport form knimeGrouping Qty by zonematching RS workzoneReplace workzoneFilterRevised Prospect Handler Employee No_SCRevised Sales Person Employee No_SCRevised missing commission codefilter rowsTableau_by office all yearNode 434Node 437Node 4432c One third prospect by RSNode 4532b Half Prospect by Prospect Office Code Node 50Node 463Node 4663 Appliance Installed by CentreNode 49Node 474Connect Access for appliance groupingrename columnNew WZ, PHE,SPERework Missing valueRead access fileRaw sheetrevised instance/ prospectNode 4992c One third prospect by RSWorkzoneNode 505Appliance Installed by work zone4b Half prospect by prospect employeeNode 508Node 509Node 512Prospect handlerTake out RSNode 515Node 517Node 518Node 519Node 520Node 521Node 522Node 5244a Appliance installed by employeecombining all employeeWorkzone4c One third prospect by work zoneNode 533Node 535Sales personTotal appliane sales by channelsRSHalf Prospect by work zoneNode 543Total appliane sales by employeeNode 545Node 547Node 549Node 550Node 552Node 554Node 556WorkzoneProspectNode 560Set missing as zeroNode 562Node 563Node 564Node 566Node 567Node 568Node 569Node 570Node 572Node 573Sales person indicatorSales person indicatorRevised sale indicatorNode 579Read EmployeeNode 582filter monthcheck by channelMonthlyreport of employee by appl type by monthNode 588Node 589Node 590Node 591Node 592Node 593revised instance/ prospectchecking the prospectchecking the prospectNode 601Node 602check missingemployeeRevised categoryfilter by monthTotal appliane sales by channelsTableau_by officereport of employee by monthTotal appliane sales by CC centrefilter RMSDTake out RSNode 614Node 615Node 616Tableau_by officeNode 618Node 619Node 620Total appliane sales by CC centrefilter monthSharan dashboardNode 624Node 625Node 626Node 627filter monthfilter monthfilter monthfilter monthfilter monthfilter monthNode 634Node 635Node 636Node 637Node 638Node 640Node 641Node 643Node 644filter monthNode 646Node 647Node 648Node 649filter monthNode 652filter monthNode 654Node 655Sharan dashboardBy groupingConnect Access for knimefilter monthTotal appliane sales by modelTotal appliane sales by employeeNode 664Take out RSMonthlyNode 670Node 671Node 672report of employee by monthTake out 0Take out 0Node 676Node 677Node 678Grouping Qty by zoneNode 680Grouping Qty by zoneGrouping Qty by zoneNode 683Node 684revised instance/ prospectNode 686Node 687filter RMSDNode 689Node 690Node 691Node 693Connect Access for appliance groupingRead sales_groupingNode 696Read sales_groupingNode 698report of Prospect matrix by monthchecking the prospectEmployee LIstNode 703Node 704Node 705filter rowsNode 707Node 708Node 709Node 710Node 711Prospect Pivot 1/2Node 713Prospect Pivot 1/3By groupingNode 716Node 717By groupingmodel filter monthRead Appliance groupingRead Appliance modelfilter monthTableau_by modelNode 726Node 727Node 728Node 730MR dashboardSharan dashboardmodel by monthNode 734Node 735Node 736Node 737revised instance/ prospectNode 739Node 740Microsoft AccessConnector DB Query Reader Column Aggregator Excel Writer (XLS)(deprecated) GroupBy Joiner (deprecated) Rule Engine GroupBy Rule Engine Rule Engine Rule Engine GroupBy Excel Writer (XLS)(deprecated) Math Formula GroupBy GroupBy Column Rename Math Formula Column Rename Math Formula Math Formula Concatenate Column Rename Math Formula Math Formula Microsoft AccessConnector Column Rename Java Snippet Missing Value Microsoft AccessConnector DB Query Reader Java Snippet Excel Writer (XLS)(deprecated) Column Rename GroupBy Math Formula Column Rename Column Rename Row Filter Math Formula Concatenate GroupBy Row Filter Math Formula Math Formula String Manipulation Joiner (deprecated) Concatenate Math Formula Math Formula Column Filter Math Formula Concatenate GroupBy Column Rename Concatenate Math Formula GroupBy GroupBy GroupBy Column Rename Math Formula GroupBy Concatenate Math Formula Math Formula String Manipulation Math Formula Rule Engine Row Filter GroupBy Math Formula Unpivoting Missing Value Column Rename Row Filter Row Filter Column Filter Column Filter Column Filter Column Filter Column Filter Math Formula Math Formula ConstantValue Column ConstantValue Column Rule Engine Joiner (deprecated) DB Query Reader Joiner (deprecated) Row Filter Row Filter Excel Writer (XLS)(deprecated) Concatenate Column Filter Column Rename Row Filter Row Filter Excel Writer (XLS)(deprecated) Java Snippet GroupBy GroupBy Row Filter Row Filter GroupBy Row Filter Row Filter GroupBy Excel Writer (XLS)(deprecated) Excel Writer (XLS)(deprecated) GroupBy Row Filter Row Filter GroupBy Row Filter Row Filter Excel Writer (XLS)(deprecated) Row Filter Row Filter GroupBy GroupBy Row Filter Excel Writer (XLS)(deprecated) GroupBy GroupBy GroupBy GroupBy Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Concatenate Concatenate Concatenate Concatenate GroupBy Joiner (deprecated) GroupBy String Replacer Joiner (deprecated) Row Filter Concatenate Column Filter(legacy) Column Filter(legacy) Rule Engine Row Filter Rule Engine Row Filter Concatenate Rule Engine Excel Writer (XLS)(deprecated) GroupBy Microsoft AccessConnector Row Filter GroupBy GroupBy GroupBy Row Filter Row Filter Column Filter Math Formula Row Filter Excel Writer (XLS)(deprecated) Row Filter Row Filter Row Filter String Replacer Rule Engine GroupBy Row Filter GroupBy GroupBy Row Filter Row Filter Java Snippet Row Filter Row Filter Row Filter Row Filter Excel Writer (XLS)(deprecated) Row Filter Rule Engine Microsoft AccessConnector DB Query Reader Joiner (deprecated) DB Query Reader Joiner (deprecated) Excel Writer (XLS)(deprecated) GroupBy Row Filter Rule Engine Rule Engine Math Formula GroupBy Row Filter Rule Engine Math Formula Row Filter GroupBy Pivoting Row Filter Pivoting GroupBy Joiner (deprecated) Joiner (deprecated) GroupBy Row Filter DB Query Reader DB Query Reader Row Filter Excel Writer (XLS)(deprecated) GroupBy Row Filter Joiner (deprecated) Row Filter Excel Writer (XLS)(deprecated) Excel Writer (XLS)(deprecated) Excel Writer (XLS)(deprecated) Row Filter GroupBy Row Filter Row Filter Java Snippet Excel Writer 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: sylvia_lin
Created at: 2020-07-08
On NodePit since: 2025-06-10
Last update: 2025-06-15
Created with KNIME version: v4.7.8

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

Try NodePit Runner!