Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am trying to concatenate several values together based on a different value which I assume requires the use of set analysis and I can't get the syntax correct. Example:
"Field 1" & " " & "Field 2" where Field 3 = "USA"
In this case, Field 3 = "USA" will only return 1 value and I'm trying to place this expression in a text object as a label.
Thanks in advance.
Concat(Distinct{$<Field3={'USA'}>}Field 1& ' '& Field 2)
Concat(Distinct{$<Field3={'USA'}>}Field 1& ' '& Field 2)
when there is space in field name, use "field name" or [field name]
for field value USA, without spaces, you can use USA or 'USA' or "USA"
concat(Distinct{$<[Field 3] ={USA}>} [Field 1] & ' ' & [Field 2] )