Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a delimited list of the intersection of possible values from the same field in alternate states to use in a Toggle Select Action?
If I have concat({[Group 1]} NAME, '|') = Bob|Tom|Harry
and concat({[Group 2]} NAME, '|') = Bob|Nick|Mike|Tom
I need Bob|Tom for my Toggle Select.
Help much appreciated.
Thanks!
hi
use
=
Concat({Group1*Group2}Distinct NAME,'|')
Thank you!