Conditional Calculation

Defining Calculations Conditions

New Column: Displays a default column name, which can be edited based on requirements.

Data Type Selection: Choose the data type for the new column from the dropdown:

• Number

• String

• Datetime

• Data

Add Rule: Define individual conditions to segment data based on specific criteria.

Add Group: Combine conditions using logical operators (AND, OR, NOT) to create complex segmentation rules.

Creating Conditions

Field Selection: Users choose the column or field from the dataset on which the condition will be applied.

Logic Condition: Users select from a range of logical operators such as

• equal to (==)

• not equal to (!=)

• Contains

• Not contains

• Is empty

• Is not empty

• Is null

• Is not null.

Input Value: Users input the value against which the selected column will be evaluated.

Calculation based on condition

After defining segmentation conditions, users can perform calculations based on these conditions using if, elif, and else statements:

• if: Mandatory initial condition.

• elif: Additional conditions that can be added if needed.

• else: Optional default condition if none of the previous conditions are met.

Users can choose from three calculation methods:

• Static Value: Assign a fixed value based on the selected data type.

• Simple Calculation: Perform basic mathematical operations.

• Advanced Calculation: Define complex expressions using available fields and operators.

Allow Duplicates toggle button

The Allow Duplicates option in the Conditional Calculation node determines how the node handles multiple rows that satisfy the same condition.

• Enabled: The node preserves all rows that meet the defined conditions, even if multiple rows have identical values.

• Disabled: The node deduplicates rows that have identical values after applying the defined conditions.

Configuration:

• New Column: DiscountAmount

• Data Type Selection: Number

If Condition

• Field Selection: Select "DPurchaseAmount" column.

• Logic Condition: Choose greater than (>)

• Input Value: 2000

  Logic Representation: ('PurchaseAmount' > 2000)

• Calculation: Choose Advanced and perform calculation

  [PurchaseAmount]*0.8

Else If Condition

• Field Selection: Select "DPurchaseAmount" column.

• Logic Condition: Choose between

• Input Value: 1500 and 2000

  Logic Representation: ('PurchaseAmount' between 1500 and 2000)

• Calculation: Choose Advanced and perform calculation

  [PurchaseAmount]*0.85

Else If Condition

• Field Selection: Select "DPurchaseAmount" column.

• Logic Condition: Choose less than

• Input Value: 1500

  Logic Representation: ('PurchaseAmount' < 1500)

• Calculation: Choose Advanced and perform calculation

  [PurchaseAmount]*0.9

Else Condition

• Calculation: Choose Advanced and perform calculation

  [PurchaseAmount]*0.95