# How can I make a join between two file?

**URL:** https://discuss.elastic.co/t/how-can-i-make-a-join-between-two-file/34923
**Category:** Elasticsearch
**Created:** [November 18, 2015, 11:07am UTC](https://discuss.elastic.co/t/how-can-i-make-a-join-between-two-file/34923 "2015-11-18T11:07:58Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![adellarocca](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@adellarocca](https://discuss.elastic.co/u/adellarocca)
#### Post date: [November 20, 2015, 10:14am UTC](https://discuss.elastic.co/t/how-can-i-make-a-join-between-two-file/34923/7 "2015-11-20T10:14:16Z")

</div>

Thank you very much warkolm! Translate filter is great!  
But now I have another problem....  
😓

> [@How can I convert to geo\_point a field extracted with translate filter?](https://discuss.elastic.co/t/how-can-i-convert-to-geo-point-a-field-extracted-with-translate-filter/35141):
>
> Hi! I have extracted geo information with translate filter using a dictionary file YAML as follow location1: 42.1497, -74.9384 location2: 34.5677, -32.8393 ......................................... The logstash conf file translate section is translate{ field =\> "ORIGIN\_STATE\_ABR" destination =\> "ORIGIN\_LOCATION" dictionary\_path =\> "/home/alessandro/Scrivania/dataset/us\_dictionary.yaml" } mutate { convert =\> { "ORIGIN\_LOCATION" =\> "string" } convert =\> { "…

😁

---

_[View the full topic](https://discuss.elastic.co/t/how-can-i-make-a-join-between-two-file/34923)._