Concatenating 3 columns using Computed columns in enhanced table

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?

I got it...

I did by using col1 ? col1 : col2 ? col2 : col3 ? col3 : "NA"

This doesn't seem related to Elasticsearch?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.