Overview

The query helper processor executes queries without any programming effort. It uses an input table instead of an SQL statement.

Input 

The processor needs two input Datasets. The first Dataset contains the actual data that needs to be queried.

The second Dataset contains the query. The query table should come with two columns, the first one represents the SELECT clause (columns to select from the Dataset) and the second one represents the WHERE clause (the condition).

Note that it's better to have every query in an independent input query table, that means the processor should only have one row per input query table. Also, the input query table shouldn't have any empty rows, otherwise the workflow won't be able to execute.

Configuration

Output

The table query is executed on the dataset connected to the left port of the processor. The output is then viewed on the linked result table.

Example

Workflow

Example Input

Dataset

Query table

Example Configuration

Result

Relevant articles

Query processor

Double Input Query Processor

Multi-Input Query Processor