This workflow is Team AST’s solution for the KNIME Game of Nodes finale. We also added a workflow with a shorter execution time, which we revisited at a later date.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Challenge of the Finale of KNIME Game of Nodes

Challenge details:

The challenge will be about data wrangling operations. You will find out the details of the task during the live event (you're welcome to ask questions if something is not clear).

Rules:

Solve task in 15 min max.

No coding allowed (e.g., Python, R, Java, etc.)

Requirements:

Import data using relative paths. In particular, place the dataset in the workflow data area and configure the reader node to import the data "Relative to" ---> "Current workflow data area".

Wrap the data wrangling operations in a configurable component (use Configuration nodes). The component must output those operations to a data table.

Name the component after your team’s name. For example, Team .

Outcome:

Deliver your solution as a separate workflow and name it: Solution_Finale_. Place your solution workflow in the same folder of this challenge workflow.

Assessment:

Your team must deliver the correct and most efficient solution:

Correctness: your solution does what we ask you to do in the task. If it does, we check for execution efficiency.

Execution efficiency: your solution must be more efficient (i.e., shorter execution time) than the solution of the other team. We'll run solutions on one of our machines.

Our benchmark is ≈18 sec.

In the event that both teams submit solutions that are perfectly correct and have the exact same execution time, we'll award the team that was faster in submitting the solution (we will verify the time of the latest edits).

In the event that both teams submit solutions that are perfectly correct but largely inefficient (execution time >= 40 sec), we'll award the team that has used the least amount of nodes.

In the event that neither of the teams delivers a fully correct solution, we'll award the team that got closer to the correct solution.

Dataset:

Provided in challenge folder.

Deadline:

April 17, 2024 (submission 15 min later after round starts)**.

** We will verify the date and time of the latest edits.

Public