Icon

module 3 ch 01 lesson 1 finished project

Where to find the source file?Right-click the workflow in the KNIME Explorer to the left and select Copy Location > Local PathOpen this in your file explorer (on Windows or Mac) and open the data folder There you will see a spreadsheet called PO Example Data.xlsx importPVO dataremove dupeentries in Vendor colremovetotal linereduce to vendor columnfilter PVOby Buyerselectedgroupvendor byPO ValueexportExcel fileget Buyerlast nameget Buyerlast nameget currentdatestring >filepathselect buyerBuyer > var Excel Reader DuplicateRow Filter Row Filter Column Filter Row Filter GroupBy Excel Writer String Manipulation(Variable) String Manipulation(Variable) Date&Time Widget String to Path(Variable) Nominal ValueRow Filter Table Rowto Variable Where to find the source file?Right-click the workflow in the KNIME Explorer to the left and select Copy Location > Local PathOpen this in your file explorer (on Windows or Mac) and open the data folder There you will see a spreadsheet called PO Example Data.xlsx importPVO dataremove dupeentries in Vendor colremovetotal linereduce to vendor columnfilter PVOby Buyerselectedgroupvendor byPO ValueexportExcel fileget Buyerlast nameget Buyerlast nameget currentdatestring >filepathselect buyerBuyer > var Excel Reader DuplicateRow Filter Row Filter Column Filter Row Filter GroupBy Excel Writer String Manipulation(Variable) String Manipulation(Variable) Date&Time Widget String to Path(Variable) Nominal ValueRow Filter Table Rowto Variable

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: philk
Created at: 2022-03-07
On NodePit since: 2022-03-25
Last update: 2024-04-28
Created with KNIME version: v4.5.1

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

Try NodePit Runner!