# Elastic with two tables. Help me :)

**URL:** <https://discuss.elastic.co/t/elastic-with-two-tables-help-me/240312>\
**Category:** Elastic Search\
**Tags:** elastic-app-search\
**Created:** [July 8, 2020, 9:18am UTC](https://discuss.elastic.co/t/elastic-with-two-tables-help-me/240312 "2020-07-08T09:18:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kate\_c](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kate_c/32/54857_2.png) [@kate\_c](https://discuss.elastic.co/u/kate_c)\
**Post date:** [July 8, 2020, 9:18am UTC](https://discuss.elastic.co/t/elastic-with-two-tables-help-me/240312/1 "2020-07-08T09:18:45Z")

</div>

I need your advice. I have two tables in one resulting addresses (1) and in the other the same addresses but with typos and abbreviations (2). I would like to match the most matching records from Table 2 to Table 1. And export them to a csv file. So in table 1 I have e.g. the key `city_street_number` and in the second I also have the key `city_street_number` and wants to match these two keys to each other based on their similarity, while in the second table I have typos. I already know how to send a file to elastic. In dev tools write a query with the selected text and as a result I have how much it matches. Now I would like me not to have to write the text and he would download the text to check from Table 1 and choose only the best matches not all. I don't think I can do it in tev tools only in the file with which I send the csv file to elastic? I work with windows.

---

<div class="post-metadata">

**Author:** ![JasonStoltz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasonstoltz/32/49893_2.png) [@JasonStoltz](https://discuss.elastic.co/u/JasonStoltz)\
**Post date:** [July 21, 2020, 7:37pm UTC](https://discuss.elastic.co/t/elastic-with-two-tables-help-me/240312/2 "2020-07-21T19:37:08Z")

</div>

Are you using the Elastic Enterprise Search or Elastic App Search products? Or are you using Elasticsearch?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 18, 2020, 7:37pm UTC](https://discuss.elastic.co/t/elastic-with-two-tables-help-me/240312/3 "2020-08-18T19:37:10Z")

</div>

Closed on August 18, 2020, 7:37pm UTC

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