Unique
The Unique() function returns the distinct rows from a range, preserving the order in which they first appear.
Syntax:
Qx.Unique(Range)- In Excel with Quintessence add-in versions prior to 25.1, use:
Unique() - In the Quintessence Editor (Studio) using Quintessence language, use:
Unique() - In the Quintessence Editor (Studio) using Python language, use:
Qx.Unique()
ⓘ See parameter descriptions
| Range | The range of data used as input. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Returning distinct rows from a single column range
Range (A1:A6):
| 4 |
| ABC |
| FALSE |
| FALSE |
| 4 |
| ABC |
Function call:
=Qx.Unique(A1:A6)Result:
| 4 |
| ABC |
| FALSE |
> Example 2: Returning distinct rows from a multi column range
Range (A1:B6):
| 4 | 1 |
| ABC | 2 |
| FALSE | 3 |
| FALSE | 4 |
| 4 | |
| ABC | 2 |
Function call:
=Qx.Unique(A1:B6) Result:
| 4 | 1 |
| ABC | 2 |
| FALSE | 3 |
| FALSE | 4 |
| 4 |