Crating visualization with two arrays in a table

Elastic Stack Kibana
#1

Hi ,
I am trying to create a table with values from two arrays
arr1[str1,str2,str30
arr2[val1,val2,val3]

desired table should be as
str1 - val1
str2 - val2
str3 - val3

and i have multiple such arrays in the json file input,
when i create the table i am getting as
str1-val1
str1-val2
str1-val3
str2-val1
str2-val2
str2-val3
str3-val1
str3-val2
str3-val3

can please help me what i should to do to get the desired output

#2

What are the mappings on your index? Are these fields already stored as arrays? Are you trying to create a Data table visualization, or Lens visualization or some other kind of table?

#3

Here is the data from my json file from the filebeat ->logstash->elastic

i want to show data in each row of the table and its respective value on the next column,
i am just a starter on kibana, thanks.

"loopdata":["data1","data2","data3","data4","data5" ]
"loopvalue":[117.8665534,118.588309,118.3033731,114.8643709,115.9260792 ]

I am creating a data table visualization ,

this is the mapping i copied only for the two field
"loopdata": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"loopvalue": {
"type": "long"
},

Another issue I have is "jobStartDateTime": "2021-02-02'T'15:50:41-00:00"
is kibana is detecting as string and not as date by itself, is there any settings I need to change

#4

Hi @Patrick_Mueller is is possible to plot the data in the table format Thanks !

#5

Here's a Discuss question + answer that's similar, regarding the array question: VIsualize 2 array in data table

For the jobStartDateTime, you should set the mapping to a date field - Date field type | Elasticsearch Reference [7.10] | Elastic