Icon

Format Excel Output - Example - 3

ImportProcurement Data 1from ExcelImportProcurementData 2from ExcelImportSupplierDetailsfrom .tablemerge 2 ProcurementDatadatasetslookup supplierdata and joinit based onSupplier Number /Supplier Namewrite to Excel file single 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 addressexecute 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 Open File or Folder Excel Cell UpdaterRef Table Converter ImportProcurement Data 1from ExcelImportProcurementData 2from ExcelImportSupplierDetailsfrom .tablemerge 2 ProcurementDatadatasetslookup supplierdata and joinit based onSupplier Number /Supplier Namewrite to Excel file single 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 addressexecute 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 Open File or Folder Excel Cell UpdaterRef Table Converter

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!