Icon

01_​Deploy_​Export_​Data_​Files

Deploy Data by Exporting Data files from KNIME

This Workflow demonstrates how the data can be exported from KNIME to various file types (.CSV or KNIME Table). It also explains how data can be written to local system or to Workflow data area.

The data can also be exported to Google Sheets using the "Google Sheet Writer" node.





Authenticate your Google Account via Sign inStep 1: Drag the "Google Authentication" node to KNIMEAnalytics PlatformStep 2: Double Click on the node to open Dialog box. In the"Authentication" tab Click on the Option "Sign in with Google"and a new tab will open in the browser. Use the browser to signin. Step 3: Select the scope of the authentication and then Click"Ok" and execute the node to finish the authentication. Write Data to Google SheetsStep 1: Drag the "Google Sheet Connection" node to KNIME AnalyticsPlatform and connect it with the output of "Google Authentication" nodeStep 2: Execute the node to establish the connection with the GoogleSheets associated with the user's account.Step 3: Connect the "Google Sheet Writer" node to output of "GoogleSheets Connection" node. Connect the data table to be written to the datainput port.Step 4: Double Click on the node to open the dialog box. Select the"Spreadsheet" and "Sheet" and click "Ok". Execute the node to write theGoogle Sheet. Writing Data to local systemTo read files from your local system follow the stepsStep 1: Drag the File reader/CSV Reader node to KNIME Analytics PlatformStep 2: Double click on the File reader/CSV Reader node and select "LocalFile System" option for Read fromStep 3: In the File option click the browse option to locate the .txt or .csv fileon your local system with respect to the nodeStep 4: After locating the file, a preview will be generated, then click Okay Step 5: Execute the node and the data will be loaded successfully Writing Data to Workflow data area using Relative PathsTo read files from your local system follow the stepsStep 1: Drag the File reader/CSV Reader node to KNIME Analytics PlatformStep 2: Double click on the File reader/CSV Reader node and select "LocalFile System" option for Read fromStep 3: In the File option click the browse option to locate the .txt or .csv fileon your local system with respect to the nodeStep 4: After locating the file, a preview will be generated, then click Okay Step 5: Execute the node and the data will be loaded successfully by workclassPivot on income byworkclassadult.data setwrite as .CSVwrite as KNIME TableWrite the Table as Google Sheeton Google DriveAccess Google SheetsSign in to your Google acccount Sorter Pivoting File Reader CSV Writer Table Writer Google SheetsWriter Google SheetsConnection GoogleAuthentication Authenticate your Google Account via Sign inStep 1: Drag the "Google Authentication" node to KNIMEAnalytics PlatformStep 2: Double Click on the node to open Dialog box. In the"Authentication" tab Click on the Option "Sign in with Google"and a new tab will open in the browser. Use the browser to signin. Step 3: Select the scope of the authentication and then Click"Ok" and execute the node to finish the authentication. Write Data to Google SheetsStep 1: Drag the "Google Sheet Connection" node to KNIME AnalyticsPlatform and connect it with the output of "Google Authentication" nodeStep 2: Execute the node to establish the connection with the GoogleSheets associated with the user's account.Step 3: Connect the "Google Sheet Writer" node to output of "GoogleSheets Connection" node. Connect the data table to be written to the datainput port.Step 4: Double Click on the node to open the dialog box. Select the"Spreadsheet" and "Sheet" and click "Ok". Execute the node to write theGoogle Sheet. Writing Data to local systemTo read files from your local system follow the stepsStep 1: Drag the File reader/CSV Reader node to KNIME Analytics PlatformStep 2: Double click on the File reader/CSV Reader node and select "LocalFile System" option for Read fromStep 3: In the File option click the browse option to locate the .txt or .csv fileon your local system with respect to the nodeStep 4: After locating the file, a preview will be generated, then click Okay Step 5: Execute the node and the data will be loaded successfully Writing Data to Workflow data area using Relative PathsTo read files from your local system follow the stepsStep 1: Drag the File reader/CSV Reader node to KNIME Analytics PlatformStep 2: Double click on the File reader/CSV Reader node and select "LocalFile System" option for Read fromStep 3: In the File option click the browse option to locate the .txt or .csv fileon your local system with respect to the nodeStep 4: After locating the file, a preview will be generated, then click Okay Step 5: Execute the node and the data will be loaded successfully by workclassPivot on income byworkclassadult.data setwrite as .CSVwrite as KNIME TableWrite the Table as Google Sheeton Google DriveAccess Google SheetsSign in to your Google acccount Sorter Pivoting File Reader CSV Writer Table Writer Google SheetsWriter Google SheetsConnection GoogleAuthentication

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2023-12-24
Last update: 2024-11-17
Created with KNIME version: v4.5.2
Tags: ReportingExcel WriterTable WriterGoogle Sheet WriterSorterGoogle AuthenticationPivotingFile ReaderBeginnerBeginner Cheat SheetBeginners Space

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

Try NodePit Runner!