Introduction to Data Workflow Value/String Operators

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 encoding of an Excel file to JSON. 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.

Formula      

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.

Includes      

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 and outputs the defined data structure as a JSON object.

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

NLP      

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.

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