# Logstash - how to configure CSV filter for joining 2 CSV files
**URL:** https://discuss.elastic.co/t/logstash-how-to-configure-csv-filter-for-joining-2-csv-files/177531
**Category:** Logstash
**Created:** [April 18, 2019, 7:26pm UTC](https://discuss.elastic.co/t/logstash-how-to-configure-csv-filter-for-joining-2-csv-files/177531 "2019-04-18T19:26:52Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@teju](https://discuss.elastic.co/u/teju)
#### Post date: [April 18, 2019, 7:26pm UTC](https://discuss.elastic.co/t/logstash-how-to-configure-csv-filter-for-joining-2-csv-files/177531/1 "2019-04-18T19:26:52Z")
I have 2 CSV Files 1 files have ip address and vsad id, the other CVS File has on ip address. may be or may not be both files has same ip address. based on file1 we should map to file 2 and we need to asign the vsad id using logstash. the output should be in json format. can some one help me how to write the path in config file. for mapping both the CSV files.
Thank you,
Chandra
---
### Author:  [@elasticforme](https://discuss.elastic.co/u/elasticforme)
#### Post date: [April 18, 2019, 7:43pm UTC](https://discuss.elastic.co/t/logstash-how-to-configure-csv-filter-for-joining-2-csv-files/177531/2 "2019-04-18T19:43:55Z")
what is common in both csv file?
---
### Author:  [@elasticforme](https://discuss.elastic.co/u/elasticforme)
#### Post date: [April 18, 2019, 7:44pm UTC](https://discuss.elastic.co/t/logstash-how-to-configure-csv-filter-for-joining-2-csv-files/177531/3 "2019-04-18T19:44:17Z")
can you post two-three line from both csv files?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 16, 2019, 7:44pm UTC](https://discuss.elastic.co/t/logstash-how-to-configure-csv-filter-for-joining-2-csv-files/177531/4 "2019-05-16T19:44:20Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.