# Problem Statement
**URL:** https://discuss.elastic.co/t/problem-statement/137073
**Category:** Elasticsearch
**Created:** [June 22, 2018, 7:01pm UTC](https://discuss.elastic.co/t/problem-statement/137073 "2018-06-22T19:01:37Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Rakesh5216](https://discuss.elastic.co/u/Rakesh5216)
#### Post date: [June 22, 2018, 7:01pm UTC](https://discuss.elastic.co/t/problem-statement/137073/1 "2018-06-22T19:01:37Z")
I have 3 different files ( 3 diff csv files) - transaction data, card info data and user data. I need to merge all these data into single file (I mean to perform SQL type join based on a key). I am aware that we canโt perform joins in elasticsearch.
So what approach to solve this problem. I need to join these documents and inject the data into single index on Kibana.
My options โ let me know if this can be possible.
Use logstash- ETL tool, do data structuring and transformation there ( is it possible to do joins in logstash? )
Or use join queries and mapping documents and inner\_hits concepts in Kibana console ?
Which of the above is feasible or if any new recommendations to solve this problem?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 22, 2018, 9:09pm UTC](https://discuss.elastic.co/t/problem-statement/137073/2 "2018-06-22T21:09:21Z")
I'd use Logstash to do it, have a look at the translate filter for eg.
---
### Author:  [@Rakesh5216](https://discuss.elastic.co/u/Rakesh5216)
#### Post date: [June 22, 2018, 9:12pm UTC](https://discuss.elastic.co/t/problem-statement/137073/3 "2018-06-22T21:12:43Z")
Thanks a ton. Can I know if any example solving related issue using translate filter?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 22, 2018, 9:21pm UTC](https://discuss.elastic.co/t/problem-statement/137073/4 "2018-06-22T21:21:18Z")
There's examples in the documentation, but also lots on here if you do a search ๐
---
### Author:  [@Rakesh5216](https://discuss.elastic.co/u/Rakesh5216)
#### Post date: [June 22, 2018, 9:35pm UTC](https://discuss.elastic.co/t/problem-statement/137073/5 "2018-06-22T21:35:06Z")
Writing a python script on the Elasticsearch end can be easier than merging on the Logstash end?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 20, 2018, 9:41pm UTC](https://discuss.elastic.co/t/problem-statement/137073/6 "2018-07-20T21:41:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.