- h3. DESCRIPTION:
The unique() function is applied to arrays in order to return a comma separated list of the unique values returned by the select() statement that created the array. Note that the parameter and returned value of the unique() function is an array.
- unique is the function keyword. This must be entered into the Ninox function editor in all lower-case characters
- x is a variable that contains (points to) the results of select statement
- Path is a series of ‘Table Names’ and, optionally, a ‘Field Name’ that indicated to Ninox where to find the contents of the array to be returned and analyzed. The path may stay inside of the family or cross over table boundaries to terminate at schema locations other than those inside the current stack or data family.
- let x := select ‘Customer Invoices’.‘Customer’.‘Customer Name’ / unique(x)