Introduction to Data Workflow Value/String Operators

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.

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.

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.

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.