Hi All

I have a formula I use in a query 

 concat.("Table 1".`Barriers`, '|', "opf_nesf_barriers".`Barriers`) as `Unified Barriers` 

The result gives me a list of values but includes duplicate values where the same value exists on both tables. (eg if "cat" exists on table 1 and table 2 i get "cat | cat" as the result in the unified Barriers Column. 

I would prefer just to get "cat" as the results.  

Any ideas to proceed. 

Thanks