# Join data from two log files/logtypes based on one common field
**URL:** https://discuss.elastic.co/t/join-data-from-two-log-files-logtypes-based-on-one-common-field/236204
**Category:** Elastic Search
**Tags:** elastic-app-search
**Created:** [June 8, 2020, 4:26pm UTC](https://discuss.elastic.co/t/join-data-from-two-log-files-logtypes-based-on-one-common-field/236204 "2020-06-08T16:26:46Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Rushabh\_Doshi](https://discuss.elastic.co/u/Rushabh_Doshi)
#### Post date: [June 8, 2020, 4:26pm UTC](https://discuss.elastic.co/t/join-data-from-two-log-files-logtypes-based-on-one-common-field/236204/1 "2020-06-08T16:26:46Z")
I have "activitylogfile" like:
PAGE,description,type
and "pagelog" like:
PAGE,activity,menu
I want to join these two files such that on kibana it could look like
PAGE,description,type,activity,menu
basically a left outer join on PAGE column, please guide if this could be done in logstash or elasticsearch end
Finally in kibana if the PAGE column data is same it should appear in same line when i select fields in kibana
---
### Author:  [@JasonStoltz](https://discuss.elastic.co/u/JasonStoltz)
#### Post date: [June 17, 2020, 3:35pm UTC](https://discuss.elastic.co/t/join-data-from-two-log-files-logtypes-based-on-one-common-field/236204/2 "2020-06-17T15:35:22Z")
Hey @ [Rushabh\_Doshi](https://discuss.elastic.co/u/Rushabh_Doshi). This is tagged as Elastic Enterprise Search and App Search, I'm wondering if this should be tagged with Kibana instead.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 15, 2020, 3:35pm UTC](https://discuss.elastic.co/t/join-data-from-two-log-files-logtypes-based-on-one-common-field/236204/3 "2020-07-15T15:35:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.