Hi Team,
Got confused while doing some calculations in Appain Expression rule. Added input and output below. i have tried fn!union() function but it was failing sine input was only one array.
Code: fn!union({ 1, 2, 2, 1, 3, 1, null, null }, {})
Sample i/p -> { 1, 2, 2, 1, 3, 1, null, null}
Expected o/p -> { 1, 2, 3}
Current Appian Design:
Thanks and Regards,
Vigneshkumar Radhakrishnan
Discussion posts and replies are publicly visible
The UNIQUE function in Excel returns a list of unique values from a range or array. It works with any data type: text, numbers, dates, times, etc.
The function is categorized under Dynamic Arrays functions. The result is a dynamic array that automatically spills into the neighboring cells vertically or horizontally.
The syntax of the Excel UNIQUE function is as follows:
UNIQUE(array, [by_col], [exactly_once])
Where:
Array (required) - the range or array from which to return unique values.
By_col (optional) - a logical value indicating how to compare data:
TRUE - compares data across columns. FALSE or omitted (default) - compares data across rows.
Exactly_once (optional) - a logical value that defines what values are considered unique:
TRUE - returns values that occur only once, which is the database notion of unique. FALSE or omitted (default) - returns all distinct (different) values in the range or array.
How does your post help the TO in Appian?