01 Deploy Export Data Files

Write data to Google Sheets

Step 1: Drag the "Google Sheet Connection" node to KNIME Analytics Platform and connect it with the output of "Google Authentication" node.

Step 2: Execute the node to establish the connection with the Google Sheets associated with the user's account.

Step 3: Connect the "Google Sheet Writer" node to output of "Google Sheets Connection" node. Connect the data table to be written to the data input 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 the Google Sheet.

Writing data to your local system

To read files from your local system follow the steps:

Step 1: Drag the ''CSV Writer'' node to KNIME Analytics Platform.

Step 2: Double click on the node and select "Output File" to write to.

Step 3: In the File option click the browse option to locate the .txt or .csv file on your local system with respect to the node.

Step 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 a workflow data area using relative paths

To read files from your local system follow the steps

Step 1: Drag the ''Table Writer'' node to KNIME Analytics Platform.

Step 2: Double click on the node and select "Output Location" to write to.

Step 3: In the File option click the browse option to locate the .txt or .csv file on your local system with respect to the node.

Step 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.

Deploy Data by Exporting Data files from KNIME

This workflow demonstrates how data can be exported from a KNIME workflow to various file types (e.g., .csv, .table (KNIME's native format), etc.) and file systems (e.g., local system, workflow data area, remote file systems like Google Cloud).

In this example, we export data to:

• A .csv file saved in your local system. Note that this option requires you to specify the file path in the CSV Writer node to make it work on your local system.

• A .table file (KNIME's native file type) saved in the workflow data area using relative paths.

• A Google Sheet. Note that this option requires you to authenticate to your Google account.

Authenticate your Google account via login

Step 1: Drag the "Google Authenticator" node to KNIME Analytics Platform.

Step 2: Click on the node to open the configuration window. Select the scope of the authentication to determine the level of permission you give (e.g., read-only or full access). Add scopes if necessary.

Step 3: Under "Authentication", click on "Login". A browser tab will open which lets you sign in to your Google account. Execute the node to finish the authentication.

Workflow complete!

Keep the momentum going by exploring Just KNIME It!on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.