Create Visualize "Data Table" with join data

[karmax (Massimiliano De Luca)]

Hi all,
I write log in elastic with logstash and I get some data from logfile and some data from mysql with jdbc query.
Now I need to concat this data.
logfile contain this fields: ipaddress, timestamp, url
mysql contain this fields: ipaddress, name
I wish to show in Data Table url, ipaddress and name where ipaddress is unique id.

This is possible? How I can create this visualization?
Thanks a lot

[spalger (Spencer Alger)]

It sounds like each document in elasticsearch has the ipaddress and name field? If you want to join them together into a single field I recommend doing that in logstash, but another option is scripted fields, which you can use to create a third field that concatenates the two fields together into a synthetic field. Scripted fields are evaluated at query time, so they aren't as performant as an actual field, but if you want to experiment around a bit before updating your logstash config they are a great option.

[karmax (Massimiliano De Luca)]

@spalger

It sounds like each document in elasticsearch has the ipaddress and name field?

No spalger.
logfile contain this fields: ipaddress, timestamp, url
mysql contain this fields: ipaddress, name

I need to concat the fields of two different rows.