Concatenation / Set Analysis Help

[#1]

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.

[venkatg6759 · Accepted solution]

Concat(Distinct{$<Field3={'USA'}>}Field 1& ' '& Field 2)

[maxgro]

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] )