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