How to execute a combined index search in Kibana / Elasticsearch?

Elastic Stack Kibana
1

I have two .csv files called Bus.csv & Tuk.csv and i have successfully imported these two files to elastcsearch. using kibana i can do the visualisation and search

How can execute a combined search/discover query using both documents data in Kibana ??

e.g - search
select * "Mobile Number" from (both csv) where "Amount > 1,000"

Bus.csv - Columns

  1. Mobile Number
  2. Age
  3. Amount

Tuk.csv - Columns

  1. Mobile Number
  2. Gender
  3. Amount
  4. Mobile Type
2

You will need an index alias across both indices that you then setup in Kibana as an index pattern.

3

how do i create index alias ?? any help be appreciated

4

Check out https://www.elastic.co/guide/en/elasticsearch/reference/7.0/indices-aliases.html

5

Thanks and it working., :slight_smile:

  • now i need to remove duplicated and merge, is there a function in kibana for this !
6

Duplicate what? They're totally different records.

7

so in this files if you take column "Mobile Number" has some documents that are repeating.

e.g same Mobile number in both files

8

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