Pairs creation

[Mazilinho]

Hello guys,

Can someone please help me with the following scenario?

I have 2 fields and i am concatenate them into one, making a pair.

Let's say i have Field 1: Tokyo, London, NY, Paris and Field 2: Berlin, LA, Rome, Rio

When i concatenate them i get: Tokyo-Berlin, Tokyo-LA, Tokyo-Rome and Tokyo-Rio; and Berlin-Tokyo, Berlin-London, Berlin-NY and Berlin-Paris. Since i already have Tokyo-Berlin, i don't want to have the other way, Berlin-Tokyo as a pair. How can i achieve this format?

Thanks!

[EdgarOlmos]

Hello.
I think, you are not concatenating the fields, rather, you are doing a Join. To have what you are looking for, what you must do is have an additional field that serves as a point of union between the values.
I attach an example:

Regards

[MarcoWedel]

If(Field1 precedes Field2, Field1&'-'&Field2, Field2&'-'&Field1) as ConcatenatedFields