Icon

08_​Google_​Sheet-meets-Excel

Public Google Sheet meets Excel Sheet.
2016 Restaurant Transactions 2017 Restaurant Transactions Semi-automatic way to build a REST query Google Sheet meets Excel Sheet Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we want to compare the monthly andYTD revenues for both years. Will Excel Sheets and Google Sheets blend? Excel sheet is accessed via an Excel Reader node; Google sheet via the new Google Sheets nodes available with KNIME Analytics Platform 3.5.This workflow demonstrates an example of access to both a public (no authorization required) or a private (OAuth2 authorization required) Google Sheetdocument. All you need is a Google account which has an access to the document.Blog post available at https://www.knime.org/blog/GoogleSheet-meets-Excel-part2 ... yes, they blend! To visualize calculate YTD valuescalculate revenuesfor each monthYTD Revenues2017 vs. 2016Monthly Revenues2017 vs. 2016join aggregated2016 and 2017dataintroduce colors for monthly andYTD revenuesPublic Access to Google Sheet with 2017 datacalculate revenuesfor each monthcalculate YTD valuesCreate connection toGoogle SheetsserviceConnect to Google2016 data Moving Aggregation Total Sum by Month Bar Chart Bar Chart Join + MissingValues Colors Google SheetsReader Total Sum by Month Moving Aggregation Google SheetsConnection GoogleAuthentication Excel Reader 2016 Restaurant Transactions 2017 Restaurant Transactions Semi-automatic way to build a REST query Google Sheet meets Excel Sheet Accounting Sheets for a Restaurant Business. In 2016 an Excel File was used. In 2017 a Google Sheet was used. Now we want to compare the monthly andYTD revenues for both years. Will Excel Sheets and Google Sheets blend? Excel sheet is accessed via an Excel Reader node; Google sheet via the new Google Sheets nodes available with KNIME Analytics Platform 3.5.This workflow demonstrates an example of access to both a public (no authorization required) or a private (OAuth2 authorization required) Google Sheetdocument. All you need is a Google account which has an access to the document.Blog post available at https://www.knime.org/blog/GoogleSheet-meets-Excel-part2 ... yes, they blend! To visualize calculate YTD valuescalculate revenuesfor each monthYTD Revenues2017 vs. 2016Monthly Revenues2017 vs. 2016join aggregated2016 and 2017dataintroduce colors for monthly andYTD revenuesPublic Access to Google Sheet with 2017 datacalculate revenuesfor each monthcalculate YTD valuesCreate connection toGoogle SheetsserviceConnect to Google2016 data Moving Aggregation Total Sum by Month Bar Chart Bar Chart Join + MissingValues Colors Google SheetsReader Total Sum by Month Moving Aggregation Google SheetsConnection GoogleAuthentication Excel Reader

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: annamartin
Created at: 2017-04-08
On NodePit since: 2019-07-12
Last update: 2024-04-22
Created with KNIME version: v4.4.0
Tags: GoogleGoogle SheetExcelExcel SheetYTDRESTREST serviceExcelwill they blend

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

Try NodePit Runner!