Icon

Format Excel Output - Example

ImportProcurement Data 1from ExcelImportProcurementData 2from ExcelImportSupplierDetailsfrom .tablemerge 2 ProcurementDatadatasetslookup supplierdata and joinit based onSupplier Number /Supplier Namewrite to Excel filegetCountryVolumesfilter outmissingcountriesturn alldata by 90 degreescreate column numbers for Excelextractrow numberfrom RowIDconvert rownumber toIntegeradd +1to every row(XL file beginsin A2)tidy uptableColumn Valuesconvertedto Stringcreatecell addressExcel 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 ImportProcurement Data 1from ExcelImportProcurementData 2from ExcelImportSupplierDetailsfrom .tablemerge 2 ProcurementDatadatasetslookup supplierdata and joinit based onSupplier Number /Supplier Namewrite to Excel filegetCountryVolumesfilter outmissingcountriesturn alldata by 90 degreescreate column numbers for Excelextractrow numberfrom RowIDconvert rownumber toIntegeradd +1to every row(XL file beginsin A2)tidy uptableColumn Valuesconvertedto Stringcreatecell addressExcel 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

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.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!