This node reads Excel files (xlsx, xlsm, xlsb, and xls format). It can read a single or multiple files at the same time, however reading only one sheet per file. The supported Excel types that can be… Learn more

This node reads a tab (sheet) of a Google spreadsheet. The spreadsheet can be selected from the spreadsheets available on Google Drive. Optionally, a specific range can be read from the sheet. The ra… Learn more

This node writes the input data table into a spreadsheet of an Excel file, which can then be read with other applications such as Microsoft Excel. The node can create completely new files or append d… Learn more

This node writes the input data table to a new Google Sheets spreadsheet. If you want to overwrite or append data to an existing sheet, you cannot use the Google Sheets Writer node; you must use the … Learn more

This node provides authentication to access Microsoft Azure and Office 365 cloud services. Learn more

This node connects to a SharePoint Online site. The resulting output port allows downstream nodes to access the document libraries of the site as a file system, e.g. to read or write files and folder… Learn more

This nodes authenticates to Google services specified in the node settings.Authentication happens in the configuration window. Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns… Learn more

This node uses a user-specified delimiter character to split the content of a selected column into parts. It appends either a fixed number of columns to the input table, each carrying one part of the… Learn more

This node sorts the rows according to user-defined criteria. In the dialog, select the columns according to which the data should be sorted. Also select whether it should be sorted in ascending or de… Learn more

Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user needs to specify in the dialog the columns of interest and some other prop… Learn more

This node evaluates a mathematical expression based on the values in a row. The computed results can be either appended as new column or be used to replace an input column. Available variables are th… Learn more

This node replaces strings in a selected target column. In the configuration dialog, a pattern and a replacement text are specified. If the pattern doesn’t match, the result string equals the input s… Learn more

This node replaces strings in selected columns. The dictionary table provides the patterns to search for and the values to replace matches with. If no pattern matches, the result string equals the in… Learn more

Update a single cell of the input table with the value of the specified flow variable. The output table will be identical to the input table except for the single updated cell. Learn more

This node concatenates two tables. The table at inport 0 is given as the first input table (top input port), the table at inport 1 is the second table, resp. Columns with equal names are concatenated… Learn more

The node has two inputs: a data table and a dictionary table. From the data table select the column that is used to look up values in the dictionary table. From the dictionary table select a column t… Learn more

This node combines two tables similar to a join in a database. It combines each row from the top input port with each row from the bottom input port that has identical values in selected columns. Row… Learn more

The Column Appender takes two or more tables and quickly combines them by appending their columns according to the order of the tables at the input ports. It simply appends columns from the second in… Learn more

The node filters an input table according to the given filter criteria. Each criterion can target the row number, RowID, or cell value of a row. Multiple criteria can be combined Learn more

This node allows columns to be filtered from the input table while only the remaining columns are passed to the output table. Within the dialog, columns can be moved between the Include and Exclude l… Learn more

The node behaves the same as a combination of the Sorter node followed by a Row Filter that only keeps the first k rows of the table except for the order of the rows which depends on the Output order… Learn more

Crops part of the input table based on the chosen column and row range. Learn more

This node helps handle missing values found in cells of the input table. The first tab in the dialog (labeled “Default”) provides default handling options for all columns of a given type. These setti… Learn more

This node identifies duplicate rows. Duplicate rows have identical values in certain columns. The node chooses a single row for each set of duplicates (“chosen”). You can either remove all duplicate … Learn more

Merges two columns into one by choosing the cell that is non-missing. The configuration dialog allows you to choose a primary and a secondary column. The output of the node will be a new column (or a… Learn more

Renames columns according to the renaming scheme defined in the dialog. Column names must be unique, hence it is not possible to give two columns the same name. Learn more

Converts strings in a column (or a set of columns) to numbers. If the node fails to parse a string, it will generate a missing cell and append a warning message to the KNIME Console with detailed inf… Learn more

Parses the strings in the selected columns and converts them into Date&Time cells. The expected format can be selected from a number of commonly used formats or specified manually (see section “Type … Learn more

Extracts the selected fields from a Local Date, Local Time, Local Date Time or Zoned Date Time column and appends their values as corresponding integer or string columns. Learn more

The node shifts a date or time with a defined duration or granularity. The user can select the Date&Time columns to shift and the shift value. The shift value can be achieved by using either a durati… Learn more