Have multiple search hits on one line


Let me start with: I am VERY new to Elastic Search and Kabana.

I have multiple indexes imported into ES and one Index Pattern between them all using a wild card so i can grab multiple fields across all indexes to make one report.

the indexes contain server information. One has basic info, another has disk info etc....

When i do a discovery and get all my columns in and then filter on a server name, i get multiple rows with each row containing information from each index.

This is expected as the info is in multiple docs.

Is there a way to combine the info into one row of output instead of multiple?

The data doesn't lend itself to a relational DB hence trying to use Elastic.