Can i join 2 fields in Kibana

Elastic Stack Kibana
1

I have two types of Tables in one index
Table A- > Internal IP Address, External IP Address, User Name, Connection Reason
Table B -> External IP Address, User Name, Session Transfer, Duration

I want to create "match the field "External IP Address" from Table A = Table B in order to get Internal IP Address in to Table B

2

You can't do this in ES either, you need to enrich the document at index time.

3

Can you please elaborate how this can be done during the index time ? We could do this in Hive or even Tableau, but how can we achieve this through ELK stack ?

4

Use Logstash and the translate filter perhaps?