# While reading one CSV file i want to lookup another CSV file for required data and that data i need to add it into my log

**URL:** <https://discuss.elastic.co/t/while-reading-one-csv-file-i-want-to-lookup-another-csv-file-for-required-data-and-that-data-i-need-to-add-it-into-my-log/177695>\
**Category:** Logstash\
**Created:** [April 20, 2019, 8:58am UTC](https://discuss.elastic.co/t/while-reading-one-csv-file-i-want-to-lookup-another-csv-file-for-required-data-and-that-data-i-need-to-add-it-into-my-log/177695 "2019-04-20T08:58:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kishore\_Kumar1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kishore_kumar1/32/44484_2.png) [@Kishore\_Kumar1](https://discuss.elastic.co/u/Kishore_Kumar1)\
**Post date:** [April 20, 2019, 8:58am UTC](https://discuss.elastic.co/t/while-reading-one-csv-file-i-want-to-lookup-another-csv-file-for-required-data-and-that-data-i-need-to-add-it-into-my-log/177695/1 "2019-04-20T08:58:59Z")

</div>

any one has any idea?

example ::

one.csv  
sno, name, address  
1,kishore,dvk  
2,rajesh,hyd  
3,geetha,nlg

two.csv  
sno, phoneNumber  
1,45678  
2,59787  
3,78974

output :::

1, kishore, dvk,45678  
2,rajesh,hyd,59787  
3,geetha,nlg,78974

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [April 20, 2019, 1:15pm UTC](https://discuss.elastic.co/t/while-reading-one-csv-file-i-want-to-lookup-another-csv-file-for-required-data-and-that-data-i-need-to-add-it-into-my-log/177695/2 "2019-04-20T13:15:01Z")

</div>

This looks like a good match for a [translate](https://www.elastic.co/guide/en/logstash/current/plugins-filters-translate.html) filter.

---

<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:** [May 18, 2019, 1:15pm UTC](https://discuss.elastic.co/t/while-reading-one-csv-file-i-want-to-lookup-another-csv-file-for-required-data-and-that-data-i-need-to-add-it-into-my-log/177695/3 "2019-05-18T13:15:09Z")

</div>

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