Two index with same field cant be merged as single document

Elastic Stack Kibana
1

Hi i'm new to Kibana.

I tried to merge two index into a single document but failed

Here what i did:

  1. Created index as index11 and index12
  2. Created index pattern as index1*
  3. then in Discover tab i can see filed of two index like below

actual

what i want ?
expected

i want like this for my further filtering and visualization

Thanks in advance

2

Hi, please check the mappings of your two indices. You can do this from Dev Tools:

GET your-index-name/_mapping

Make sure that your common field of the two indices have the same mapping. If they don't, you'll want to update your mappings and reindex your data.

1 Like
3

Hi , I tried both are in having same mapping

can you tell the place where i need to mention the common field which is present in two indexes ?

tele1

tele2

4

Any comments ?

6

Good question!

7

The two lines correspond to two different documents and as these have different sets of fields you see this. Displaying the data the way you would like would require a join on the common field. This is not possible as Elasticsearch does not support joins.

8

And assuming all fields were the same? is there a way to join the two indices?

9

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