# Use of Split Filter for more than 1 fields, it is possible

**URL:** <https://discuss.elastic.co/t/use-of-split-filter-for-more-than-1-fields-it-is-possible/97687>\
**Category:** Logstash\
**Created:** [August 20, 2017, 1:26pm UTC](https://discuss.elastic.co/t/use-of-split-filter-for-more-than-1-fields-it-is-possible/97687 "2017-08-20T13:26:17Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![rkhapre](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rkhapre/32/48333_2.png) [@rkhapre](https://discuss.elastic.co/u/rkhapre)\
**Post date:** [August 28, 2017, 6:03pm UTC](https://discuss.elastic.co/t/use-of-split-filter-for-more-than-1-fields-it-is-possible/97687/12 "2017-08-28T18:03:47Z")

</div>

Hi @magnusbaeck

I have followed your suggestion

I am able to achieve transpose of the array and able to get the record in this below format.  
But now i am not able to split the records in multiple events. After applying split filter i am getting one records which is the last row of record.

Please help me to get multiple records

```
{
	"id" : "1",
	"author" : "author1",
	"desc" : "Description for 1",
	"date" : "Jun 18, 2017 1:48:43 PM"
}, {
	"id" : "2",
	"author" : "author2",
	"desc" : "Description for 2",
	"date" : "Jun 21, 2017 1:48:43 PM"
} 

```

I have followed the concept given over here

> [@Xml filter array](https://discuss.elastic.co/t/xml-filter-array/96055/9):
>
> I'm getting there step by step. ruby { code =\> " event.set('mksrevision', [event.get('ID'), event.get('author'), event.get('desc'), event.get('date')].transpose) array\_of\_hashes = event.get('mksrevision').collect { |i| {'id' =\> i[0], 'author' =\> i[1], 'desc' =\> i[2], 'date' =\> i[3]}} event.set('mks', array\_of\_hashes) "} this creates an array "mks" wich basically has the richt structure I need to parse each array elemnt as a seperate document to elasticsearch. edit: got it after …

---

_[View the full topic](https://discuss.elastic.co/t/use-of-split-filter-for-more-than-1-fields-it-is-possible/97687)._