Jq filter compilation (jqcompile)
How does it work in the search window?
Select Create column in the search window toolbar, then select the Jq filter compilation operation. You need to specify one argument:
The filter to locate the part of the json syntax from which to extract the data. You can manually enter the string or select a column with string data type.
For a successful extraction using it as an argument in the Jq evaluation (jqeval) operation, the jq filter specified must coincide with the name of an item inside the intended JSON and must start with a dot operator (.) – jq filters always start with a dot.
The data type of the values in the new column is jq.
In this example, we will create a jq filter to locate a specific item inside a JSON, which can be later used as an argument in the Jq evaluation (jqeval) operation.
- Click the Create Column button on the toolbar, select the Jq filter compilation (jqcompile) operation and give the new column a name.
- Add the necessary argument and configure it as shown in the picture below:
- jq → manually introduced → .city
- Click Create Column and a new column will be created with the specified jq filter.
Now you have your new column ready to use as an argument in the Jq evaluation (jqeval) operation.
How does it work in LINQ?
Use the operator
as... and add the operation syntax to create the new column. This is the syntax for the Jq filter compilation operation:
You can use the following LINQ script to recreate the example above in any table (for example, in
from demo.ecommerce.data select jqcompile(".city") as jqFilter