topic Pairs creation in App Development

Pairs creation

Mazilinho — Wed, 07 Sep 2022 08:30:51 GMT

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!

Re: Pairs creation

EdgarOlmos — Tue, 20 Sep 2022 14:24:30 GMT

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

Re: Pairs creation

MarcoWedel — Tue, 20 Sep 2022 16:57:26 GMT

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