Icon

01_​Advanced_​Queries

Indexing and querying data tables

Demonstrates the power of advanced queries to filter a given data table based on the values of several columns at once.
The table to be searched in is first indexed. Once the index has been created it can be queried using a powerful query language.
The query syntax bases on the Lucene query syntax and supports among others phrase queries, wildcard queries, fuzzy queries, proximity queries, range queries, term boosting, grouping and boolean operators.

This workflow demonstrates the power of advanced queries to filter a given data tablebased on the values of several columns at once.For more information see the workflow metadata. Find it here: View -> Description Create index from the customer data for searching100kcustomersearch for male customerswhere the first name starts with A, B or Cand the last name does not start with A, B or Cage is between 20 and 40 yearslives in the postcode area between 30000 and 40000 (Germany) Table Indexer File Reader Index Query This workflow demonstrates the power of advanced queries to filter a given data tablebased on the values of several columns at once.For more information see the workflow metadata. Find it here: View -> Description Create index from the customer data for searching100kcustomersearch for male customerswhere the first name starts with A, B or Cand the last name does not start with A, B or Cage is between 20 and 40 yearslives in the postcode area between 30000 and 40000 (Germany)Table Indexer File Reader Index Query

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: 2019-07-12
Last update: 2024-04-24
Created with KNIME version: v4.1.1
Tags: ETLqueryadvanced query

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

Try NodePit Runner!