If (Int64)

Name

If (Int64)

Syntax

If (Boolean condition, Integer thenValue, Integer elseValue)

Purpose

To evaluate a given condition and if true, return result of thenValue. Otherwise, to return the result of elseValue.

Description

Returns the value of ‘Then’ expression or ‘Else’ expression depending on the value of condition.

Return Type

Int64

Parameters

Condition [System.Boolean] – Condition that is evaluated

thenValue [System.Int64] – This Parameter’s value is returned if the result of ‘condition’ parameter is true.

elseValue [System.Int64] - This Parameter’s value is returned if the result of ‘condition’ parameter is false.

Example

We have a Customers dataset which we will use to evaluate and transform the Items field.

In this example we will use the Expression object to define the condition, and a Variables object to define thenValue and elseValue.

Where,

Condition: Items = “1”

thenValue = 100

elseValue ­ = 200

In the output, you can see that Integer values, 100 and 200, have been returned depending on whether the Items field condition was met.

Last updated

© Copyright 2023, Astera Software