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?
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, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.