# Merge and transform more than one csv or json files to elasticsearch from logstash or ingest node pipeline (beginner)
**URL:** https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503
**Category:** Logstash
**Created:** [August 23, 2019, 11:01am UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503 "2019-08-23T11:01:53Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@namali](https://discuss.elastic.co/u/namali)
#### Post date: [August 23, 2019, 11:01am UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503/1 "2019-08-23T11:01:53Z")
I wanted to know how to merge and transform more than one csv or json files to elasticsearch from logstash or ingest node pipeline.
\*hotel.csv
hotelcode
hotelname
starcode
\*star.csv
starcode
starrating
after merge index should have
hotelcode
hotelname
starcode
starrating
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [August 23, 2019, 2:05pm UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503/2 "2019-08-23T14:05:55Z")
Use a [translate](https://www.elastic.co/guide/en/logstash/current/plugins-filters-translate.html) filter.
---
### Author:  [@namali](https://discuss.elastic.co/u/namali)
#### Post date: [August 25, 2019, 4:27am UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503/3 "2019-08-25T04:27:25Z")
Thanks, I will try and see
---
### Author:  [@namali](https://discuss.elastic.co/u/namali)
#### Post date: [August 26, 2019, 11:00am UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503/6 "2019-08-26T11:00:31Z")
this works from translate. Thx
---
### Author:  [@namali](https://discuss.elastic.co/u/namali)
#### Post date: [August 27, 2019, 5:24am UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503/7 "2019-08-27T05:24:38Z")
this works when key field is in first column in dictionary\_path data file. I want to know how to merge files when key field is not in first column
translate {
destination =\> "[@metadata][lookup1]"
dictionary\_path =\> "/home/namalie/elk/test/starrating.csv"
field =\> "starcode" }
dissect { mapping =\> { "[@metadata][lookup1]" =\> "%{starrating}" } }
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 24, 2019, 5:24am UTC](https://discuss.elastic.co/t/merge-and-transform-more-than-one-csv-or-json-files-to-elasticsearch-from-logstash-or-ingest-node-pipeline-beginner/196503/8 "2019-09-24T05:24:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.