Query Helper Processor

Modified on Tue, 30 Nov 2021 at 02:49 PM


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.



Example Input


Query table

Example Configuration


Relevant articles

Query processor

Double Input Query Processor

Multi-Input Query Processor

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article