### Author:  [@marwa](https://discuss.elastic.co/u/marwa)
#### Post date: [August 8, 2017, 8:14am UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/3 "2017-08-08T08:14:42Z")
thank you for your reply
i used mutate in the config file as bellow
filter {
csv {
separator =\> ","
#transaction\_date,customer\_name,age,job,fidelity\_card\_id,product\_id\_sold,quantity
columns =\> ["transaction\_date","customer\_name","age","job","fidelity\_card\_id","product\_id\_sold","quantity"]
}
date {
match =\> ["transaction\_date", "M/d/yyyy;HH:mm:ss"]
target =\> "transaction\_date"
```
}
```
mutate {
convert =\>{"age" =\> "integer" }
split =\> { "quantity" =\> "," }
split =\> { "product\_id\_sold" =\> ","}
}
}
the fields are still strings have a look at the mapping in kibana
so they didn't turn into array of integers i also had this warn when loading data with logstash
[WARN][logstash.filters.csv] Error parsing csv {:field=\>"message", :source=\>"", :exception=\>#\}
2017-08-08T08:10:19.855Z vds002.insightscale.tn transaction\_date,customer\_name,age,job,fidelity\_card\_id,product\_id\_sold,quantity
maybe the problem maintains in the format of the csv file !!!
this is the JSON document
"product\_id\_sold": [
"723",
" 334",
" 297",
" 666",
" 182",
" 530",
" 978",
" 133",
" 229",
" 281"
],
---
### Author:  [@marwa](https://discuss.elastic.co/u/marwa)
#### Post date: [August 8, 2017, 10:18am UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/4 "2017-08-08T10:18:17Z")
so now i only need to covert the string value into integers ,i tryed it with convert but it did not work
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [August 8, 2017, 11:06am UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/5 "2017-08-08T11:06:33Z")
Please show your current configuration where you try to convert the elements of `product_id_sold` to integers.
---
### Author:  [@marwa](https://discuss.elastic.co/u/marwa)
#### Post date: [August 8, 2017, 11:41am UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/6 "2017-08-08T11:41:17Z")
filter {
csv {
separator =\> ","
#transaction\_date,customer\_name,age,job,fidelity\_card\_id,product\_id\_sold,quantity
columns =\> ["transaction\_date","customer\_name","age","job","fidelity\_card\_id","product\_id\_sold","quantity"]
}
date {
match =\> ["transaction\_date", "M/d/yyyy;HH:mm:ss"]
target =\> "transaction\_date"
```
}
```
mutate {
convert =\>{"age" =\> "integer" }
split =\> { "quantity" =\> "," }
split =\> { "product\_id\_sold" =\> ","}
convert =\> {"product\_id\_sold" =\> "integer"}
}
}
---
### Author:  [@marwa](https://discuss.elastic.co/u/marwa)
#### Post date: [August 8, 2017, 1:43pm UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/7 "2017-08-08T13:43:25Z")
how should i fix this ?
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [August 9, 2017, 5:36am UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/8 "2017-08-09T05:36:48Z")
Mutate actions aren't applied in the order listed in the configuration file. Their execution order is fixed, and it so happens that `convert` is applied before `split`. So, split your mutate filter into at least two to make sure the split takes place before you attempt the conversion.
>
---
### Author:  [@marwa](https://discuss.elastic.co/u/marwa)
#### Post date: [August 9, 2017, 12:04pm UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/9 "2017-08-09T12:04:39Z")
thank u a lot it worked for me
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 6, 2017, 12:04pm UTC](https://discuss.elastic.co/t/configure-a-list-of-integers-with-logstash/96098/10 "2017-09-06T12:04:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.