Array of mixed types not working correctly
When we have an array of type [String, number], the second item is considered as string and hence, not able to do aggregation like sum.
For example, consider
```
$project: {
transposed: {
$zip: {
inputs: [["aaa","bbb"], [1, 2]]
}
}
}
I am not able to create a data table with transformed.0 in col1 and max(transformed.1) in col2
1
vote
![](https://secure.gravatar.com/avatar/e835f6e58d2e3310b6423589957e7ebf?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
AdminTom (Product Manager, MongoDB) commented
You should be able to use the Convert Type option to convert the array to numbers. Any non-numeric values will be converted to null, and the numeric accumulates should work.