# How to use mutate to flatten dataset

**URL:** <https://discuss.elastic.co/t/how-to-use-mutate-to-flatten-dataset/106529>\
**Category:** Logstash\
**Created:** [November 6, 2017, 1:17pm UTC](https://discuss.elastic.co/t/how-to-use-mutate-to-flatten-dataset/106529 "2017-11-06T13:17:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![charmingmel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/charmingmel/32/23891_2.png) [@charmingmel](https://discuss.elastic.co/u/charmingmel)\
**Post date:** [November 6, 2017, 1:17pm UTC](https://discuss.elastic.co/t/how-to-use-mutate-to-flatten-dataset/106529/1 "2017-11-06T13:17:13Z")

</div>

Hi there,

I am new to logstash. Please I need a little help transforming my dataset to a file so that it can be easy to query.

Data set:  
`{ "parent_id": "e4a085a9-0ec0-d4f4-0047-eab10eca4f79", "year": "2017", "month": "Jul", "day": "1", "doc": { "abcdef12-0ec0-d4f4-0047-eab10eca4f79.assessmentId": "abcdef12-0ec0-d4f4-0047-eab10eca4f79", "abcdef12-0ec0-d4f4-0047-eab10eca4f79.assessmentName": "Lesson Review ", "abcdef12-0ec0-d4f4-0047-eab10eca4f79.username": " mildred akinyi", "abcdef12-0ec0-d4f4-0047-eab10eca4f79.start_time": 1499064558217, "a5425e8f9e034cc5e44780a5e2000338.lesson_success": "Teacherfollowed the guide", "a5425e8f9e034cc5e44780a5e2000338.teacher_visit": "0", "a5425e8f9e034cc5e44780a5e2000338.teacher_talk": "9", "a5425e8f9e034cc5e44780a5e2000338.timestamp": 1499065466036 } }`

Expected Result:  
`{ "parent_id": "e4a085a9-0ec0-d4f4-0047-eab10eca4f79", "year": "2017", "month": "Jul", "day": "1", "doc": { "assessmentId": "abcdef12-0ec0-d4f4-0047-eab10eca4f79", "assessmentName": "Lesson Review ", "username": " mildred akinyi", "start_time": 1499064558217, "lesson_success": "Teacherfollowed the guide", "teacher_visit": "0", "teacher_talk": "9", "timestamp": 1499065466036 } }`

---

<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:** [December 4, 2017, 1:17pm UTC](https://discuss.elastic.co/t/how-to-use-mutate-to-flatten-dataset/106529/2 "2017-12-04T13:17:17Z")

</div>

Closed on December 4, 2017, 1:17pm UTC

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