Icon

5W_​Report

Data Input Data Transformation Data Output #Steps: #1) Download the returned file from MIMU - they've done the checking and cleaned the data as necessary. Save in "1) Returned updated files"#2) Save the same file in "2) Files used for script" and change the headers to align with headers used in the script. #3) Update the directory link, file title, update date info on the script (Look for "#EDIT")#4) Run the script. Save the exported file under "3) Updated info after script"#5) Open the exported file, and copy and paste the info to the returned updated file. Save as final report under "4) Final reported file" from Operations from MIMU (sent to us via email) from MIMU (master Pcode file)might need to use the latestversion MIMU pcodes CustomersTransactions# EditsFiles used for script/Feb 2026.xlsxPcode_list_version9.3_draft.xlsxCust_transactionProximity_Pcodedf1Pcode formatTop: ^MMRBottom: digitlegitimatePcodesYetagon Business onlyProject_yearProject TitleSub_sectorProject_monthdf6OrganizationSectorProject_statusOpen_Restricted#EditsLast Data Updated dateTake the last updated 5W report and use outer-join to set aside pcodes that are already reported. Node 28Node 29#Editsfile name to be editedExcel Reader CSV Reader Excel Reader Excel Reader GroupBy GroupBy Joiner Rule-basedRow Splitter String To Number Row Filter Number To String Concatenate Cell Splitter Column Filter Column Rename Rule-basedRow Filter Rule Engine Rule Engine Rule Engine Rule Engine Joiner Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine ReferenceRow Filter String Manipulation GroupBy Excel Writer Data Input Data Transformation Data Output #Steps: #1) Download the returned file from MIMU - they've done the checking and cleaned the data as necessary. Save in "1) Returned updated files"#2) Save the same file in "2) Files used for script" and change the headers to align with headers used in the script. #3) Update the directory link, file title, update date info on the script (Look for "#EDIT")#4) Run the script. Save the exported file under "3) Updated info after script"#5) Open the exported file, and copy and paste the info to the returned updated file. Save as final report under "4) Final reported file" from Operations from MIMU (sent to us via email) from MIMU (master Pcode file)might need to use the latestversion MIMU pcodes CustomersTransactions# EditsFiles used for script/Feb 2026.xlsxPcode_list_version9.3_draft.xlsxCust_transactionProximity_Pcodedf1Pcode formatTop: ^MMRBottom: digitlegitimatePcodesYetagon Business onlyProject_yearProject TitleSub_sectorProject_monthdf6OrganizationSectorProject_statusOpen_Restricted#EditsLast Data Updated dateTake the last updated 5W report and use outer-join to set aside pcodes that are already reported. Node 28Node 29#Editsfile name to be edited Excel Reader CSV Reader Excel Reader Excel Reader GroupBy GroupBy Joiner Rule-basedRow Splitter String To Number Row Filter Number To String Concatenate Cell Splitter Column Filter Column Rename Rule-basedRow Filter Rule Engine Rule Engine Rule Engine Rule Engine Joiner Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine ReferenceRow Filter String Manipulation GroupBy Excel Writer

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: NE-2193
Created at: 2026-03-23
On NodePit since: 2026-09-04
Last update: 2026-09-04
Created with KNIME version: v4.5.2

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

Try NodePit Runner!