Concat attributes as string

[cezarykac]

Hi,

I would like to concatenate attributes like

RETURN a.x + ',' + a.y

The problem is when y doesn't exist it returns null:

a.x + ',' + null - returns null instead of a.x

Any idea why it works this way and how to correctly concat attributes ?

Regards,
Cezary

[intouch_vivek]

Hi Cezary,

try RETURN COALESCE(a.x ,"") + ',' + COALESCE(a.y ,"")

Regards
Vivek

[cezarykac]

Hi Vivek,

Thank you 🙂 it works!

Best,
Cezary