Using Data Transformations and Logic in Workflows
Last updated July 30, 2024
Enflow's capabilities extend beyond simple data transfers, enabling you to manipulate and process data within workflows using transformations and logical operations, making your automations even more powerful.
Data Transformations
- Data Formatting: Convert data from one format to another, such as:
- Text to Number: Convert a text string representing a number into a numerical value for calculations.
- Date/Time Manipulation: Parse dates and times, calculate durations, or format dates for specific purposes.
- String Manipulation: Trim whitespace, extract specific parts of strings, or convert case for text-based data.
- Data Calculations: Perform mathematical calculations:
- Basic Operations: Add, subtract, multiply, divide, and calculate percentages.
- Advanced Functions: Utilize functions like logarithms, exponentials, and trigonometric calculations.
- Data Aggregation: Combine data from multiple sources:
- Concatenation: Combine multiple text strings into a single string.
- List Aggregation: Combine data from multiple lists or arrays into a single list.
Logical Operations
- Conditional Statements: Control the flow of your workflow based on data values and conditions:
- IF-THEN-ELSE: Execute different actions based on whether a specific condition is met or not.
- CASE Statements: Branch your workflow logic based on multiple possible conditions.
- Comparison Operators: Compare data values:
- Equals: Check if two values are equal.
- Not Equals: Check if two values are not equal.
- Greater Than/Less Than: Compare numerical or alphabetical values.
- Logical Operators: Combine multiple conditions:
- AND: Check if all conditions are true.
- OR: Check if at least one condition is true.
- NOT: Negate a condition.
Example Use Cases
- Calculating Discounts: Automate discount calculations based on customer purchase history or loyalty status.
- Generating Reports: Aggregate data from multiple sources and generate customized reports.
- Personalizing Communications: Filter leads or customers based on specific criteria and tailor communication based on individual preferences.
- Enriching Data: Combine data from multiple sources to create a more comprehensive view of your customers or products.
Enflow's data transformation and logical capabilities provide you with the flexibility to create sophisticated automations that intelligently process and manage your data, automating tasks that would otherwise require manual intervention and complex coding.
Was this article helpful?