The following works:
=UNIQUE(ARRAY(1 1 2) => [1 2]
The following does not work:
=UNIQUE(MAP(FLATTEN(SIBLINGS.actions) x => x.owner)) => array with duplicate string values
The MAP returns an array but UNIQUE just ignores it. Does anyone have a solution for this?
Page 1 / 1
Just figured out a work around for this.
=UNIQUE(MAP(FLATTEN(SIBLINGS.actions) x => CONCATENATE(x.owner ""))) => Returns Unique Values
For some reason Concatenating the return value to an Empty String makes UNIQUE work even though it is already a string.
If anyone knows a better way to make this a string please comment below.
Hi Craig
Thanks for posting your workaround. I have noted the confusion here and let our developers know. Let us know if you run into any other issues.
-KB
Reply
Create an account in the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
Log in to the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Login with SSO
Log in with Lucidor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.