Getting full string in Kibana Datatable

[Abdul_Jaleel]

One of the field I have with value is listed below
"Category": [
"Book",
"Novel",
"English"
]

Creating datatable visualization with term shows only Category.keyword. since Category is non Aggregatable . Creating datatable with Category.keyword splits the value into 3 records and listing 3 entries. I need to create data table which will list all 3 values as "Book, Novel, English"

[lukeelmers]

Hi @Abdul_Jaleel,

You could try using scripted fields to do this. By creating a string field that joins the items in the list together, you might get the result you are looking for:

doc['category'].join(', ')

This should convert ["Book", "Novel", "English"] to "Book, Novel, English"

Then just use your new scripted field in the data table visualization instead