Icon

Format Excel Output - Example - 2

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 addressnumerics to topusing regex pattern^-?\d+(\.\d+)?$set data typeexecute to viewoutput foldercreate NumericColumnValuescolumnTable of refupdatesExcel 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 Open File or Folder Column Renamer Concatenate 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 addressnumerics to topusing regex pattern^-?\d+(\.\d+)?$set data typeexecute to viewoutput foldercreate NumericColumnValuescolumnTable of refupdatesExcel 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 Open File or Folder Column Renamer Concatenate

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-05-19
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!