| Table of Contents | ||||
|---|---|---|---|---|
|
Description
Converts a string data type into json data type, which is required as an argument for the Jq evaluation (jqeval) operation.
How does it work in the search window?
Select Create column in the search window toolbar, then select the To json operation. You need to specify one argument:
Argument | Data type | Description |
|---|---|---|
String to convert |
mandatory |
string | The full sample with json syntax. You can manually enter the string or select a column with json data type.
|
The data type of the values in the new column is json.
Example
In this example, in the demo.ecommerce.data table, we will manually specify a string to create a json column, which can be later used as an argument in the Jq evaluation (jqeval) operation.
Click the Create Column button on the toolbar, select the To json (jsonparse) operation and give the new column a name.
Add the necessary argument and configure it as shown in the picture below:
string to convert → manually introduced → {"name":"John","birth":"1986-12-14","city":"New York"}
Click Create Column and a new column will be created with the specified string in json data type.
...
Use the operator select... as... and add the operation syntax to create the new column. This is the syntax for the To json operation:
jsonparse(string)
Example
You can use the following LINQ script to recreate the example above in any table (for example, in demo.ecommerce.data):
...