Icon

Format Excel Output - Example - 1

ImportProcurement Data 1from ExcelImportProcurementData 2from ExcelImportSupplierDetailsfrom .tablemerge 2 ProcurementDatadatasetslookup supplierdata and joinit based onSupplier Number /Supplier Namewrite to Excel file - 1st passgetCountryVolumesfilter outmissingcountriesturn alldata by 90 degreescreate column numbers for Excelextractrow numberfrom RowIDconvert rownumber toIntegeradd +1to every row(XL file beginsin A2)tidy uptableColumn Valuesconvertedto Stringcreatecell addressnumerics to topusing regex pattern^-?\d+(\.\d+)?$set data typewrite to Excel fileusing intermediatexlsx as templateexecute to viewoutput folderExcel Reader CSV Reader Table Reader Concatenate Joiner Excel Cell Updater GroupBy Row Filter Unpivot Rule Engine String Manipulation String to Number Math Formula Table Manipulator String Manipulation String Manipulation Row Splitter Column AutoType Cast Excel Cell Updater Open File or Folder ImportProcurement Data 1from ExcelImportProcurementData 2from ExcelImportSupplierDetailsfrom .tablemerge 2 ProcurementDatadatasetslookup supplierdata and joinit based onSupplier Number /Supplier Namewrite to Excel file - 1st passgetCountryVolumesfilter outmissingcountriesturn alldata by 90 degreescreate column numbers for Excelextractrow numberfrom RowIDconvert rownumber toIntegeradd +1to every row(XL file beginsin A2)tidy uptableColumn Valuesconvertedto Stringcreatecell addressnumerics to topusing regex pattern^-?\d+(\.\d+)?$set data typewrite to Excel fileusing intermediatexlsx as templateexecute to viewoutput folderExcel Reader CSV Reader Table Reader Concatenate Joiner Excel Cell Updater GroupBy Row Filter Unpivot Rule Engine String Manipulation String to Number Math Formula Table Manipulator String Manipulation String Manipulation Row Splitter Column AutoType Cast Excel Cell Updater Open File or Folder

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: 2024-05-06
On NodePit since: 2024-05-07
Last update: 2024-11-17
Created with KNIME version: v5.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!