# How to visualize data from different CSV file?

**URL:** <https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448>\
**Category:** Kibana\
**Created:** [August 18, 2020, 2:43pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448 "2020-08-18T14:43:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![atiqah\_yusri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/atiqah_yusri/32/73958_2.png) [@atiqah\_yusri](https://discuss.elastic.co/u/atiqah_yusri)\
**Post date:** [August 18, 2020, 2:43pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448/1 "2020-08-18T14:43:42Z")

</div>

Hi everyone, I already load 2 CSV files into the elasticsearch. so, now I want to visualize them using kibana, but not all data I want to visualize.

for example:  
-csv\_1: have columns name [Student name, student id, gender, course name]  
-csv\_2: columns name [student id, test1 score, test2 score]

I want to visualize [student name, student id, test1 score, test2 score] in a table. Means that student name data takes from csv\_1, test1 score and test2 score takes from csv\_2. My question is, how to visualize these data (from 2 csv file)?

---

<div class="post-metadata">

**Author:** ![poff](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/poff/32/81795_2.png) [@poff](https://discuss.elastic.co/u/poff)\
**Post date:** [August 18, 2020, 9:21pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448/2 "2020-08-18T21:21:01Z")

</div>

Hey there!

ES doesn't really provide a way to do joins across indexes on fields like ID. You might consider processing your data before loading it into ES by generating just one CSV that includes all the information from both CSVs

---

<div class="post-metadata">

**Author:** ![atiqah\_yusri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/atiqah_yusri/32/73958_2.png) [@atiqah\_yusri](https://discuss.elastic.co/u/atiqah_yusri)\
**Post date:** [August 24, 2020, 1:33pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448/3 "2020-08-24T13:33:33Z")

</div>

ouh really? Thank you so much Poff for this info.

---

<div class="post-metadata">

**Author:** ![atiqah\_yusri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/atiqah_yusri/32/73958_2.png) [@atiqah\_yusri](https://discuss.elastic.co/u/atiqah_yusri)\
**Post date:** [August 24, 2020, 3:19pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448/4 "2020-08-24T15:19:24Z")

</div>

Hi poff,

You mentioned that ES not really provide a way to joins across indexes. What if I put different CSV files in the same index id?

```auto
   input{
    file{
        #first scv file
        path => "C:/Users/Win 10/Desktop/Iqah/datasets/mockdataset/MOCK_DATA.csv"
        start_position => "beginning"
        sincedb_path => "NULL"
    }

    file{
        #second csv file
        path => "C:/Users/Win 10/Desktop/Iqah/datasets/mockdataset/MOCK_DATA testscore.csv"
        start_position => "beginning"
        sincedb_path => "NULL"
    }
}

filter{
    if [path] == "C:/Users/Win 10/Desktop/Iqah/datasets/mockdataset/MOCK_DATA.csv"{
        csv{
            separator => ","
            columns => ["student_ID","student_name","gender","email"]
        }

    }
    else if [path] == "C:/Users/Win 10/Desktop/Iqah/datasets/mockdataset/MOCK_DATA testscore.csv"{
        csv{
            separator => ","
            columns => ["student_ID","test1_score %","Test2_score %"]
        }

        mutate {convert => ["test1_score %", "integer"]}
        mutate {convert => ["Test2_score %", "integer"]}

    }

}

output{
    elasticsearch{
        hosts => "http://localhost:9200"
        index => "studentscore"
        document_type => "studentscore_dataset"
  }
  stdout{}
}

```

---

<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:** [September 21, 2020, 3:19pm UTC](https://discuss.elastic.co/t/how-to-visualize-data-from-different-csv-file/245448/5 "2020-09-21T15:19:52Z")

</div>

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