# Can i join 2 fields in Kibana
**URL:** https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506
**Category:** Kibana
**Created:** [November 25, 2015, 1:51am UTC](https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506 "2015-11-25T01:51:37Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@mathews.lintu](https://discuss.elastic.co/u/mathews.lintu)
#### Post date: [November 25, 2015, 1:51am UTC](https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506/1 "2015-11-25T01:51:37Z")
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
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 25, 2015, 2:25am UTC](https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506/2 "2015-11-25T02:25:21Z")
You can't do this in ES either, you need to enrich the document at index time.
---
### Author:  [@mathews.lintu](https://discuss.elastic.co/u/mathews.lintu)
#### Post date: [November 26, 2015, 1:12am UTC](https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506/3 "2015-11-26T01:12:09Z")
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 ?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 26, 2015, 8:34pm UTC](https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506/4 "2015-11-26T20:34:18Z")
Use Logstash and the translate filter perhaps?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:08pm UTC](https://discuss.elastic.co/t/can-i-join-2-fields-in-kibana/35506/5 "2017-07-06T14:08:10Z")