Logstash CSV adding multiple rows by splitting a column value

Elastic Stack Logstash
1

Hello,

I am importing csv file to elasticsearch using logstash.

I need to duplicate a row based on a comma separated column values. This is how the data looks.

image

I want to add multiple rows based on the number of values in the column 'category' as below.

image

Kindly suggest me on how to achieve this using logstash.

Thanks

2

Use mutate+split to convert the [category] field to an array, then use a split filter to convert that to multiple events.

1 Like
3

This worked! Thank you so much. I really appreciate for helping me.

4

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