Icon

R_​LP_​testt

Read CT dataCount rowsCount columnsDefinevariableLP SolveAdd high CTwhere volumehas not to beallocatedFilter out1st columnRead volume dataJoin CT andvolumeUnpivot CTdataMissing CTon zeroResortColumnsColumn names:MACHINEPRODUCTCTRow_IDoutSort byMACHINEUnpivot volume dataColumn names:VOLUMEPERIODCTxVolumeSum CTxVolumeby PERIOD andMACHINESum Volumeby PERIOD andMACHINEChange volumeon 0where CT=0JOIN DATACalculateWEIGHTED CTby MACHINE andPERIODRead TIMEdataJoin availabletimeCalculatemachine capacitybased on W_CTFilter outcolumnsPivotingFilter outPeriod1Node 37Extract columnnamesFilter outPERIODcolumnNode 40Node 41Node 42Node 43Excel Reader (XLS) Extract TableDimension Table Rowto Variable R Snippet Missing Value Column Filter Excel Reader (XLS) Joiner Unpivoting Missing Value Column Resorter Column Rename Column Filter Sorter Unpivoting Column Rename Math Formula GroupBy GroupBy Rule Engine Joiner Math Formula Excel Reader (XLS) Joiner Math Formula Column Filter Pivoting Row Filter Table Columnto Variable ExtractColumn Header Column Filter Table Rowto Variable Create CollectionColumn Column Filter Column Rename Read CT dataCount rowsCount columnsDefinevariableLP SolveAdd high CTwhere volumehas not to beallocatedFilter out1st columnRead volume dataJoin CT andvolumeUnpivot CTdataMissing CTon zeroResortColumnsColumn names:MACHINEPRODUCTCTRow_IDoutSort byMACHINEUnpivot volume dataColumn names:VOLUMEPERIODCTxVolumeSum CTxVolumeby PERIOD andMACHINESum Volumeby PERIOD andMACHINEChange volumeon 0where CT=0JOIN DATACalculateWEIGHTED CTby MACHINE andPERIODRead TIMEdataJoin availabletimeCalculatemachine capacitybased on W_CTFilter outcolumnsPivotingFilter outPeriod1Node 37Extract columnnamesFilter outPERIODcolumnNode 40Node 41Node 42Node 43Excel Reader (XLS) Extract TableDimension Table Rowto Variable R Snippet Missing Value Column Filter Excel Reader (XLS) Joiner Unpivoting Missing Value Column Resorter Column Rename Column Filter Sorter Unpivoting Column Rename Math Formula GroupBy GroupBy Rule Engine Joiner Math Formula Excel Reader (XLS) Joiner Math Formula Column Filter Pivoting Row Filter Table Columnto Variable ExtractColumn Header Column Filter Table Rowto Variable Create CollectionColumn Column Filter Column Rename

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: RolandMAC
Created at: 2020-11-27
On NodePit since: 2022-02-06
Last update: 2024-11-17
Created with KNIME version: v4.2.3

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

Try NodePit Runner!