KNIME Fundamentals Expand Excellence

Explore KNIME fundamentals in the nine fundamentals masterclass to master workflow controls, if conditions and switches, time-triggered automations, and database operations with the included database and sample workflows.

Build a KNIME workflow that reads flat files and creates a country and product pivot with totals. Export a PDF report and automate via a wait node for time events.

Learn to use KNIME's timer info to measure execution time for individual and aggregated notes, identify bottlenecks in large workflows, and optimize by replacing or rebuilding slower notes.

Learn how to terminate KNIME workflows with a breakpoint inside a loop, using list files and folders, table to variable, Excel reader, and transfer files to copy only non-empty data.

KNIME's if switch and end illustrate how to route data with conditional filtering, control active ports via flow variables and single selection configurations, and tailor workflows.

Explore seven KNIME case switch conditions, including data, model, and variable cases; configure ports, apply single selection and flow variables, and generate pivoted, grouped sales reports.

Handle no data in KNIME by using empty tables to route data to the correct output. The lecture shows a real-world workflow that transfers files only when data exists.

Learn to handle errors in Knime with try catch nodes to continue workflows after failures, using breakpoint checks and alternative results to keep data processing moving.

Acquire hands-on guidance on the Java if table in KNIME by configuring an integer input, linking data ports, and returning zero or one to control flow.

Learn to handle API request errors in KNIME by using try catch with get requests, validating URLs from a data table, and looping with an ultimate result for failures.

Call KNIME workflow from your current workflow using the call workflow table based node. Configure container input and output, set decimal separator to comma, and execute to produce total sales.

Learn how to connect KNIME to databases such as SQLite and SQL Server, use generic and specific connectors, read data via table selectors or custom SQL queries, and preview results.

Learn how to connect KNIME to a database, create and populate a new table from Excel data using the DB writer node, and verify results with a refreshed table reader.

Learn how KNIME performs aggregations, sorting, and grouping inside the database using DB Group II and DB Sorter to avoid loading data into KNIME, revealing performance advantages.

Explore database operations in KNIME using the SQLite connector, including the db euro filter note and db roll filter note, using placeholders for like conditions and left joins.

Explore KNIME data filtering with row filter, rule-based filter, and nominal value filter on a Pokémon dataset, using regex and include or exclude criteria.