Icon

Marketing_​Monitoring_​Dashboard_​Excel

Marketing Monitoring Dashboard with Excel
Creating a Marketing Monitoring Dashboard with Excel. Combines several workbooks from a folder into a unique Excel workbook.Apply Formatting to the table and conditional formatting to the values of the resulting Excel workbook.Generate trend charts and inject them into the Excel workbook.For more information, see the workflow metadata. Find it here: View -> Description. 1- Combine Multiple Excel Files into a unique TableReset the whole workflow before re-execute it! 2- Creating standalone worksheets and formatting them3- Creating Charts for each iteration and injecting into the worksheet 4- Merge formatting andapplying it to the Exceloutput Input FolderIterate for eachfolderAll files (+100)in one Tableconvert the XLSFormatting port objectto a table cell forloop-collection ofresults per sheetcopy/pastable componentthat recursively mergesa column's XLS Formatterport objects to oneIterate for eachAcquisition Channel.new sheet for each oneDelete output fileto apply formatChart Generation Excel Reader List Files/Folders Table Row ToVariable Loop Start Loop End Model to Cell Merge Ports Grouping byYearWeek Group Loop Start Pivoting the data Excel Writer Applying Formatting andConditional Formatting XLS Formatter(apply) Loop End DeleteFiles/Folders Pivoting the data Excel Writer KNIME Workflow DataArea Connector KNIME Workflow DataArea Connector KNIME Workflow DataArea Connector Creating a Marketing Monitoring Dashboard with Excel. Combines several workbooks from a folder into a unique Excel workbook.Apply Formatting to the table and conditional formatting to the values of the resulting Excel workbook.Generate trend charts and inject them into the Excel workbook.For more information, see the workflow metadata. Find it here: View -> Description. 1- Combine Multiple Excel Files into a unique TableReset the whole workflow before re-execute it! 2- Creating standalone worksheets and formatting them3- Creating Charts for each iteration and injecting into the worksheet 4- Merge formatting andapplying it to the Exceloutput Input FolderIterate for eachfolderAll files (+100)in one Tableconvert the XLSFormatting port objectto a table cell forloop-collection ofresults per sheetcopy/pastable componentthat recursively mergesa column's XLS Formatterport objects to oneIterate for eachAcquisition Channel.new sheet for each oneDelete output fileto apply formatChart GenerationExcel Reader List Files/Folders Table Row ToVariable Loop Start Loop End Model to Cell Merge Ports Grouping byYearWeek Group Loop Start Pivoting the data Excel Writer Applying Formatting andConditional Formatting XLS Formatter(apply) Loop End DeleteFiles/Folders Pivoting the data Excel Writer KNIME Workflow DataArea Connector KNIME Workflow DataArea Connector KNIME Workflow DataArea Connector

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: markus.gohm
Created at: 2022-10-13
On NodePit since: 2022-10-19
Last update: 2024-04-26
Created with KNIME version: v4.6.3
Tags: ExcelExcel FormattingExcel_to_KNIMEExcel_sheet_loopConditional FormattingXLS Conditional FormatterDashboard#marketing automationMarketing

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!