Introduction to Data Workflow Value/String Operators

Estimated Reading Time:  3 minutes


The Value/String operators let you convert Excel files into JSON JSON (JavaScript Object Notation) is an open standard file and data interchange format. Unqork uses JSON for submission (record) data., convert a JSON string to a JSON object, and find matching values in a table.

What You'll Learn

In this article, you'll get an overview of the various Data Workflow Value/String operators.

Value/String Operators

Below is a list of the Data Workflow Value/String operators with descriptions of how to use them.



Convert Value

Converts a value from one data type to another based on the value selected in the Cast To setting. From this drop-down menu, you can select Number, Integer, or String. The input must be a single key/value pair. To convert to a Number or Integer, the input must be a numeric value. When converting to an Integer, any values after the decimal are removed and not rounded.

Create Value

Lets you create a value and pass it into the Data Workflow. This operator can create a number, string, or Boolean value. You can either set the value directly in the Value/Expression field or use _arg to reference the input connected to the top argument port. This operator is commonly used with an Output operator to set values for Post Triggers.

Excel to JSON

Converts the Base64 Base64 is an encoding and decoding technique used to convert binary data to an ASCII (American Standard for Information Interchange) text format. encoding of an Excel file to JSON JSON (JavaScript Object Notation) is an open standard file and data interchange format. Unqork uses JSON for submission (record) data.. Data in the sheet is converted into a headings array and a JSON array. The headings array contains the file's header fields. The JSON array contains the file contents. We recommend using an Excel file that contains headers. Doing so ensures the JSON array has key/value pairs, where the key corresponds to the header.


Performs calculations on your data based on the formula defined in the Formula/Expression field. You can use an alias of A to represent the data coming into the input port. You can also use _arg to reference values coming into the top argument port. For example, the expression =A*12 multiplies your input by 12. The expression =A*_arg multiplies your input by the value entered in the argument port.


Determines if a specified value exists in the input. Then, it outputs a Boolean value. The input should be a value or an array of values. In the Value field, enter a value to determine if it is included in your data set. If your data includes that value, the output is True. If not, the output is False.

JSON Parse

Parses a string containing properly-formatted JSON JSON (JavaScript Object Notation) is an open standard file and data interchange format. Unqork uses JSON for submission (record) data. and outputs the defined data structure as a JSON object.

TIP  You can use a Hidden component as the input, where the Hidden component's Default Value contains the formatted JSON.


Compares text entering the upper input port to a data set in the lower input port. Then, it outputs an array listing any matching keywords and their corresponding Values. For example, you can create a data table with column names Keyword and Mood. Then, connect it to the NLP operator's lower input port. This is your Keyword vs. Mood table. In the Keyword column, create a list of words. In the Mood column, assign emotions (moods) to each word. In the NLP operator's Source Column field, enter Keyword. When the operator finds a match between the text in your input and the keywords in your table, it adds the Keyword/Mood pair as the output.

Split String

Splits a string into an array of values. In the Separator field, enter the separator to split the value on. The separator is not included in the final arrays.

NOTE  The default separator is a comma. If the string is comma-separated you can leave the Separator field blank.