The query helper processor executes queries without any programming effort. It uses an input table instead of an SQL statement.
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.
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.