Hi all,
There are 3 fields a,b,c . For every document, only 1 of them will have a value.
So I'm trying to concatenate 3 columns , but it is showing null with the string.
For example : document 1:
a=Hi
b=
c=
When i concatenate using col1 || col2 || col3
it shows Hinullnull
I dont want null, I want to only display Hi.
I'm not supposed to use scripted fields as this is slowing my response times.
Any ideas for the this?