To perform compute tasks in workflows:
- Drag and Drop the Compute Field from the workflow controls available on the left side of the page.
- Right-click the Compute Task node to access three options: Properties, Delete, and Duplicate.
- Select Properties to view the Compute Task properties.
- Enter a Name and select a data type for your computation: Number, Date, Date & Time, or String.
- For “Number” computations, input the formula in the text box under the Formula section. You can map number fields from previous tasks or manually input data to achieve the desired results. Click the “Save” button.
- If you choose “Date” or “Date & Time,” select the operation you wish to perform: “Add,” “Subtract,” “Between,” or “Duration.”
- For “Add” and “Subtract,” input the number of days, weeks, months, or years to modify the date.
- Inputs like “Number” and “Date” can be mapped from previous tasks or entered as constant values.
- For “Between” and “Duration,” choose the type and specify the two date & time values.
- If you select “String,” you can choose to concatenate fields or extract a substring.
- To concatenate multiple strings, select “Concat” and choose the columns you want to combine.
- To extract a specific word from a text field, choose “Substring,” then map the columns, and provide the “start_index” and “end_index.”
