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:
When i concatenate using
col1 || col2 || col3 it shows
I dont want null, I want to only display
I'm not supposed to use scripted fields as this is slowing my response times.
Any ideas for the this?